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.96) (envelope-from ) id 1w5k82-003a5r-2q for pgsql-novice@arkaria.postgresql.org; Thu, 26 Mar 2026 12:48:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5k7z-002lDc-34 for pgsql-novice@arkaria.postgresql.org; Thu, 26 Mar 2026 12:48:00 +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.96) (envelope-from ) id 1w5k7z-002lDU-2H for pgsql-novice@lists.postgresql.org; Thu, 26 Mar 2026 12:48:00 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5k7y-000000018lP-0S2V for pgsql-novice@lists.postgresql.org; Thu, 26 Mar 2026 12:47:58 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-4043b27ddeaso604512fac.1 for ; Thu, 26 Mar 2026 05:47:58 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774529277; cv=none; d=google.com; s=arc-20240605; b=LFp4DaZntu9DID6Q3FgqazhD81g+CIg/5ZOMtwuf7C/1D+QDouVYJuZmHNfk12zZ7+ KsuzWU4rnr1aRAPxHcXgxBne4Qsz3QnYZI0Mn9okDsaXLvmD+ouL122+v5UrYb1dnJA0 KIYNek82PaOG+lthQgFF9B+ygOnyVmYYbzJbzQ0SXO6ZyQGb4SH45dPgG3fQiGczGrM+ +yZHyWY5/8YhEV45LbiBkzpOWpwzZQ1q8yjcMRS0w26Sw0rde9pVKp095f7WnIAgpNMO naINjmNLLDI4xGtv6GwXrHbyGrTWrGVxapYC58XEuDWv5Ou2DTWQtG+H81uOhT4gNB9W 5KhQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=m+2q3tNRrgfDGXghTwX7TSPIpT24nqLs60KiD1ldRO8=; fh=4YP8/ObuFdNE7FLzoa2GUFMCmfYVDd3/chevNTaOUVE=; b=TvLvnVPASrZ+P//SBMvdZsGvGh+FkEQRIMeliSeOXq440J1TtdCvYNbd7vVpc2fgVr x+qwiLTtxqwLYQWTdH7lujpeKSogK9X2fy5KY3GSKh4Tg3eh1QACHfZAfuptJKamvLv6 lhy5suvECjoYCe8elHd6RqM8KgEsdnaHTN5gx94cqA3wJC7k/E453ULNpWxh+w7Xf3ms P+Sa5lbDY9iFI2Dt1IQ5b8Dw0p2Sd5wWon801cIT7XvLXhZpt3G5SSgB3hQlsefOu1o2 UVSU25iTwXj2mC4Mj7eYuoGJq77OzMy04z1VuJGNDqAh9jvd78t3srrmcQsFDU7sz2CL c6bw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774529277; x=1775134077; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=m+2q3tNRrgfDGXghTwX7TSPIpT24nqLs60KiD1ldRO8=; b=Go6ldYbvkI95aMrXAOKxereQ7naIXLdl6balXOXHGtkcSGf7QtKBoZLFH1hn2tprWf Fr7oiKV0EDHK2MWgXPG8QxaaIUyR7HKuQfBIxFDoXxz7/5GkDWruAbg5JMCRTDtYS0Ir WQQ7EZsqJ7wRvi42OQPgweSGDBMXR5wJEE5ACgmr7o3omdQ14XbR7hW47+izoD8NukbD uXUbXoYlKVg6hHGcu+yLSh7U8k+kNXU8/bMjhk4Jan+Sa3Cz+IaN1RIYaN1xvh23xa9i Dzqp/kU2ZvcxC1oOKuBPpdElBSC71V7zyVhhXXfkDgg4xP2hbk0Cuy6bg85XX5MO0C1G RNeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774529277; x=1775134077; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=m+2q3tNRrgfDGXghTwX7TSPIpT24nqLs60KiD1ldRO8=; b=nEsuzE9ARXeNgF3jhB3M5WksiJrLe0wtd8wcIBjJDUtBDlsGz7OKwxGxxoHvmG44CV Z+U5C57jIm9DdKOuhZLNlwvVwsq+5LLmoBhYpx8imPs/XO/9lJnVkMegn4LI7MlssdvC TkUR3n0Wo0LPcDZr1QUsIU1JbEf86JHsI63YFOLbwcoJ6VWpPJjIKB+kXYtUQ9ikOLg7 iUfqYvNPzhNWPK2c97PNF8IGq5HBy9cUjYOxbtihDFYfyDeRzu5mTWnrowX8U2ALZ2Yk G8VxWPvDwWTgK/ZJqnp3M8/oLKAl442MXsfaVfB1T1fvXJVB422ucT0He2+eZARAv3zd xosg== X-Gm-Message-State: AOJu0YzDIB9OpOTNGHJMdsaU7xmP1JyjTTevA7Kr23wQebfQZJu2NiBW NMnKu0lMgC6tFGI9UrU4VGPA/kvANYaXnKXQy7yctwy/H5SJ8Y+sOtbLSeIoo8XX91PH+6GsTE+ yyfvvFfGw8gnboP4BZdxZbxM2jX+aBBI= X-Gm-Gg: ATEYQzz1LqA6tdzpmgDh4t+qlk+rUIKVJKdO2IYvz4YpoPd4p+Q3YieZq+2XuwgDm3q J/nvKJhQS5mZUtTvhgMlkt0trrNVEgv6LXwsIwaN+NcByqbQ1EieOtOb0YLg61FvHoSTi3XbdRp aq3ZdtR5KYbLAKgoaxXb3jsxgy9Rxw1K3MOKaqy7UjXhV3uvRTVurrFapglTUq2E3El1wcFmL8Q bEyps9SVrQghaRL+skUbFM0m14P0IjtAenorzwCYj73OnwjHQX3u4b6GYWF/qJmwgmIZm1JEstk 2kLqJU3T6u1LNsaPFuKfRJMOruBjNx0t7VghVX/Wdda8+YvRXlo= X-Received: by 2002:a05:6870:b015:b0:40e:e9ab:f6f4 with SMTP id 586e51a60fabf-41ca6d4b3cbmr3983867fac.9.1774529277122; Thu, 26 Mar 2026 05:47:57 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:63c2:b0:625:cca5:18c9 with HTTP; Thu, 26 Mar 2026 05:47:56 -0700 (PDT) In-Reply-To: <5604c5c610e44a0d97daceaf5f1ae01f@alte-leipziger.de> References: <5604c5c610e44a0d97daceaf5f1ae01f@alte-leipziger.de> From: "David G. Johnston" Date: Thu, 26 Mar 2026 05:47:56 -0700 X-Gm-Features: AQROBzBtJX3jxmUzDYdmKh3LZXegN_vt16a-kbBjKjLEP5Cj-KyCl33THnjp32c Message-ID: Subject: Re: Very basic question about Archive logs To: "Subramanian,Ramachandran" Cc: "pgsql-novice@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000034e4d9064deccb06" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000034e4d9064deccb06 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, March 26, 2026, Subramanian,Ramachandran < ramachandran.subramanian@alte-leipziger.de> wrote: > > If I apply the base backup from Monday 0100 , how does Postgres know whic= h > Archive Logs need to be applied from its current state to get to the > PIT. Obviously when the basebackup was taken, the now needed logs did no= t > exist. So this information cannot have been recorded during the backup. > > We=E2=80=99ve documented how to actually use the software. https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PI= TR-RECOVERY David J. --00000000000034e4d9064deccb06 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, March 26, 2026, Subramanian,Ramachandran <ramachandran.subramanian@alte-= leipziger.de> wrote:

If I apply the base backup from Monday 0100 , how does Postgres= know which Archive Logs need to be applied from its=C2=A0current s= tate to get to the PIT.=C2=A0 Obviously when the basebackup was taken, the now needed logs did not exist= . So this information cannot have been recorded during the backup.

We=E2=80=99ve documented how to actually use the s= oftware.


David J.

--00000000000034e4d9064deccb06--