Search Postgresql Archives

Re: PgBackRest : Restore to a checkpoint shows further transactions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux