Point-in-time recovery after failover

2018-03-13 Thread Dylan Luong
Hi We are on Postgres 9.6 and we have primary/standby wal replication setup for HA. For PITR, we have scheduled nightly base backup and hourly archive backups on the primary server. https://www.postgresql.org/docs/9.6/static/continuous-archiving.html I am trying to perform a point-in-time recov

Re: Point-in-time recovery after failover

2018-03-13 Thread Laurenz Albe
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