Re: PgBackRest : Restore to a checkpoint shows further transactions

2024-09-25 Thread Greg Sabino Mullane
On Wed, Sep 25, 2024 at 2:13 AM KK CHN wrote: > PgBackRest : I tried to restore the latest backup taken at my RepoServer > to a testing EPAS server freshly deployed . > ... > Now I comment out the archive command in the test EPAS server > postgresql.conf and started the EPAS server. > * To d

Re: PgBackRest : Restore to a checkpoint shows further transactions

2024-09-25 Thread Adrian Klaver
On 9/24/24 23:12, KK CHN wrote: List, PgBackRest :  I tried to restore the latest backup taken at my WHen I issue a query  to select few rows  To my surprise  I am seeing the records with columns with time stamp up to a time 10.36:11:968  and 10:36:13.363 : How did this happen ?   I sp

PgBackRest : Restore to a checkpoint shows further transactions

2024-09-24 Thread KK CHN
List, PgBackRest : I tried to restore the latest backup taken at my RepoServer to a testing EPAS server freshly deployed . I have a full backup, two diff and one INCR as on today morning. The latest one is INCR full backup: 20240922-232733F timestamp start/stop: 2024-09-2