Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQCG2-00HCJG-M2 for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Jan 2024 20:11:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rQCF3-00FKBZ-Jt for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Jan 2024 20:10:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQCF3-00FKBR-6D for pgsql-hackers@lists.postgresql.org; Wed, 17 Jan 2024 20:10:29 +0000 Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rQCF0-0022N1-Li for pgsql-hackers@lists.postgresql.org; Wed, 17 Jan 2024 20:10:27 +0000 Received: by mail-lf1-x133.google.com with SMTP id 2adb3069b0e04-50e5a9bcec9so14086606e87.3 for ; Wed, 17 Jan 2024 12:10:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705522225; x=1706127025; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=yTyb1XnzlWRmF1AMpP7WND1feV4iXq0q6YpPkl/b2z0=; b=MIBWNT6CsfJkez2kM1hRErC8lvXYzzM0SJQFtiXLEmCYEqn+psKxQrzClIWAFIEkaB vma1ei/nlLtKbQsfPCC68wKjQrrP1h7QdB5uND15xJwY9zujENNYv0OUt6XnTBWo2wOK jM0dDWLejeJK7bc5OBLNnGd4oveNRRUGCd7UHhoZjnZqyxjoDqAqFGC+JPndGbwaxKgO gmZbuNAWpqILVyglfQXRoLW4XCSI6HDpK7x4mxUjwOWMIf3e55TLrjbIceM4BqYICrm1 8J0+X+SyuHE+yRkgh2IhrI2+66ilp4ynggTLEZ0KyF0LLh5d6BsZoNl3pwdiKwXJdP14 2ssw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705522225; x=1706127025; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=yTyb1XnzlWRmF1AMpP7WND1feV4iXq0q6YpPkl/b2z0=; b=KkfmatiMEp1YHZS4fd1orEkXv07QIWJcA+FzK4HyyWHuTlvKEOpa1mQvGq23uPzGK6 jiD07c/k4dy1NlX2LeTc4ZCloQc/aQW7Oc1E6Eixj5OKvpHuGCX0gza8pqgepg19DfuL qQ9jqtJCPCvX/Q5fU8IWwaMR2cYVghvbL3kgSLrJPWo4orIuPi1DRtOqrQQdT1RTktcW C7M5ZoiWWe1RGh6Rw5XlTvBRLFRvc+zeG++5GYam5ECfADjNuYpxMofiX+4sJjw7MprJ G0LjS4ZLDAPzoXxSnVTGD3oOvEcUw+yZZ/20gqGA6FSaOh3IGu5ZD3jJU5m9IykSpRNQ CUaw== X-Gm-Message-State: AOJu0YyNPv1bv8B0b3WUpu3ZtGQv7NAEh8TkMCjIs3UNE0n0K7vfnEVB 9ai6WDHaQ6LqtuJ95heRs371j7lroCa59Sr/4Ek= X-Google-Smtp-Source: AGHT+IFClr2MloOXHIIW9lIWgt/htbCJj6ne2/aLDhoYtgyJHWhlVftx1a8dOO3TOSHS5Yeiy24+H+aRZ/SxvUtPmyQ= X-Received: by 2002:ac2:4c01:0:b0:50e:699b:55f with SMTP id t1-20020ac24c01000000b0050e699b055fmr4207757lfq.66.1705522224804; Wed, 17 Jan 2024 12:10:24 -0800 (PST) MIME-Version: 1.0 References: <212b0987-83e5-e2ae-c5e8-b8170fdaf3a0@gmail.com> In-Reply-To: From: Robert Haas Date: Wed, 17 Jan 2024 15:10:13 -0500 Message-ID: Subject: Re: cleanup patches for incremental backup To: Matthias van de Meent Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jan 17, 2024 at 1:42=E2=80=AFPM Matthias van de Meent wrote: > Sure, added in attached. I think this mostly looks good now but I just realized that I think this needs rephrasing: + To restore incremental backups the tool + is used, which combines incremental backups with a base backup and + WAL to restore a + database cluster to + a consistent state. The way this is worded, at least to me, it makes it sound like pg_combinebackup is going to do the WAL recovery for you, which it isn't. Maybe: To restore incremental backups the tool is used, which combines incremental backups with a base backup. Afterwards, recovery can use WAL to bring the database cluster to a consistent state. --=20 Robert Haas EDB: http://www.enterprisedb.com