I'm asking this because Postgres was hard-stopped yesterday, and I fear that there could be partial / corrupt data in one of my archived log segments. I'd like to simply delete the logs from my slave server and just have Postgres start again from the beginning (there are only about 90 segments, so it won't take long), but I'm not sure what to do, to get Postgres to do this.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
On master there is archive_status directory in pg_xlog which contains files that mark status of archiving of xlogs.