Verifying a PITR

Started by james bardinover 16 years ago1 messagesgeneral
Jump to latest
#1james bardin
jbardin@bu.edu

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