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:30:24Z
Lists: pgsql-novice 
On Thursday, March 26, 2026, Subramanian,Ramachandran <
ramachandran.subramanian@alte-leipziger.de> wrote:

> Further more, if I execute the PIT-recovery On Tuesday at 0005 Hours and
> specify a Target recovery time of Monday 2300 Hours, then  Postgres will
> look at the active logs and any archive logs ( if it does not already exist
> in the active logs ) that were written between Tuesday 0005 Hours and
> Monday 2300 Hours and use these logs to Undo all the changes to the current
> Database. Is my understanding correct?
>
> There is no rolling back.  You deploy the base backup first to 0100
Monday, then it would apply the WAL up to the target time.

David J.