Verifying a PITR - Mailing list pgsql-general

From james bardin
Subject Verifying a PITR
Date
Msg-id a3b675320909040926h4c6b695he262b4a7e22529b9@mail.gmail.com
Whole thread Raw
List pgsql-general
What would be the best way to verify that a PITR came up with *all*
the expected data?

This is mostly for a controlled failover, where I manually bring down
the primary server, and shouldn't ever lose a transaction.
If I need to use something like txid_current(), how do I ensure that
it's the last transaction before shutdown, and the first after
recovery?


Thanks
-jim

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: where clause question
Next
From: Jeff Davis
Date:
Subject: Re: Moving avg using SQL