| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | KK CHN <kkchn(dot)in(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PgBackRest : Restore to a checkpoint shows further transactions |
| Date: | 2024-09-25 15:36:13 |
| Message-ID: | 406ca824-5a65-4b6e-8f36-92ac9128a9e1@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 specified the restore point file (incr) taken
> at 2024-09-25 08:26:37, naturally I expected restore may show records
> up to this time stamp or up to2024-09-25 08:36:00+05:30 but it shows
> further to 10.36:11:968 and 0:36:13.363 but not beyond this !!!
0:36:13.363 of what date?
What is the type of the timestamp fields you are looking at, timestamp
or timestamptz?
> Thank you,
>
> Krishane.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2024-09-25 17:22:31 | Re: Repeatable Read Isolation Level "transaction start time" |
| Previous Message | Greg Sabino Mullane | 2024-09-25 14:42:07 | Re: Logical Replication Delay |