Greetings,
Please don't top-post.
* Ron (ronljohnso...@gmail.com) wrote:
> Search the log file for errors?
Sadly, this doesn't actually work if you're really doing PITR- you need
to look for the specific message saying "recovery stopping before
commit" or similar, eg:
2020-08-18 12:55:31.240 UT
Search the log file for errors?
Query the database(s) to verify that the latest data s there?
On 8/18/20 5:10 AM, Daulat Ram wrote:
Hello Team,
I want to know the best way to ensure/verify that the Point in time
recovery has done successfully after the crash and the restore.
Thanks,
--
Dylan Luong wrote:
> We are on Postgres 9.6 and we have primary/standby wal replication setup for
> HA.
>
> I am trying to perform a point-in-time recovery after a failover has occurred.
>
> I extracted the base backups (tar files) to the data directory and extracted
> the all the archive ba
