public inbox for pgsql-novice@postgresql.org  
help / color / mirror / Atom feed
From: David G. Johnston <david.g.johnston@gmail.com>
To: Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: Re: Very basic question about Archive logs
Date: Thu, 26 Mar 2026 05:47:56 -0700
Message-ID: <CAKFQuwbBeAs4j=9nPGXJrFopBa5kJDJs5LzDn6bAH5Fs+gczxg@mail.gmail.com> (raw)
In-Reply-To: <5604c5c610e44a0d97daceaf5f1ae01f@alte-leipziger.de>
References: <dee8d2457c034cddb7ab7021e1caf3f7@alte-leipziger.de>
	<CAKFQuwZwA=sq7xeLV032QJCzZ99NQnq8SNg4a6Y_hBxN_D=PmA@mail.gmail.com>
	<5604c5c610e44a0d97daceaf5f1ae01f@alte-leipziger.de>

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 current state to get to the
> PIT.  Obviously when the basebackup was taken, the now needed logs did not
> exist. So this information cannot have been recorded during the backup.
>
> We’ve documented how to actually use the software.


https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PITR-RECOVERY

David J.


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-novice@postgresql.org
  Cc: david.g.johnston@gmail.com, ramachandran.subramanian@alte-leipziger.de, pgsql-novice@lists.postgresql.org
  Subject: Re: Very basic question about Archive logs
  In-Reply-To: <CAKFQuwbBeAs4j=9nPGXJrFopBa5kJDJs5LzDn6bAH5Fs+gczxg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox