Restoring Postgres standby

[michaelmclean]

We have a master/standby setup for analytics

While doing some testing we took the standaby down for around a week, we found when we brought it back it was not able to catch up to the master due to Write Ahead Logs not being present as it had been down for so log

We need to bring this back up to date with the master but are a little unsure how to do this?

My thoughts were to stop the standby, remove all data then start it again and hope the replication would occur? or is there a better way to do this

Thanks 🙂

[cjking]

You're on the right track. The steps you need are steps 5-7 of the replication setup https://docs.apigee.com/private-cloud/v4.19.01/set-master-standby-replication-postgres

This will force the secondary to re-download all data from the master.