I have a PostgreSQL 9.1 hot standby slave that had all of its wal files removed. How can I restart the standby server and have the slave resync from the master? Thanks
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Feb 11 '13 at 12:46
This question came from our site for professional and enthusiast programmers.
If the WAL files don't exist anymore anywhere, you need to rebuild the standby from scratch (new base backup). If you still have the WAL files on the master or in an archive somewhere, just change the