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.
Postgresql – How does Postgres know which logs have been archived
archivepostgresqlpostgresql-9.2rdbms
Related Question
- Postgresql – Cannot get the slave – replication server to start
- PostgreSQL – WAL Files Not Deleting During PITR
- PostgreSQL – Fix ‘Role Postgres Does Not Exist’ Error After Renaming User
- PostgreSQL – How to Restore Backup with WAL-E
- How Does PostgreSQL Store Many Varchars on Disk?
- Postgresql – postgres: could not receive data from WAL stream: ERROR: requested WAL segment has already been removed
- PostgreSQL 11 – Service Doesn’t Start Troubleshooting
Best Answer
On master there is archive_status directory in pg_xlog which contains files that mark status of archiving of xlogs.