Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

On master there is archive_status directory in pg_xlog which contains files that mark status of archiving of xlogs.

share|improve this answer
    
Awesome, thanks depesz! –  orokusaki Jun 21 '13 at 14:23
    
FWIW, I did delete all the archives from my slave, then deleted all the .done files from my master's archive_status directory while the server was off. When I restarted the server the archive process started like normal, but no archiving is taking place (over 40 min, and no archives have been moved - rsync hasn't been used once). Fortunately, I'm only using this environment to learn in, but I'd be interested to know what happened when I deleted the archive status files and started the server again. –  orokusaki Jun 21 '13 at 15:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.