Thursday, August 25, 2011

pgpool-II & the recovery.conf file

I spent some time scratching my head about the recovery process  based on archived logs. I followed this guide to the letter:   and although I had successfully performed it, I didn't know how the hell the postgresql server knew  that I wanted to do a database recovery. It turns out that if the startup process (postmaster) finds a recovery.conf file in the database cluster, it reads the recovery command contained inside it, performs the recovery, and then renames it to "recovery.done". I should say this is a rather peculiar recovery mechanism. =-D

No comments:

Post a Comment