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.
