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: pgpool.projects.postgresql.org/contrib_docs/pgpool-II_for_beginners.pdf   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

http://pgpool.projects.postgresql.org/pgpool-II/doc/recovery.conf.sample

No comments:

Post a Comment