Horton

Re: Very basic question about Archive logs

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
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>
Date: 2026-03-26T12:47:56Z
Lists: pgsql-novice 
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.