Well, I do keep a recovery.conf master file in the Postgres home directory on each of the systems. My failover script takes care of copying it up into the data directory, as well as making any required changes to it. (I use two standby servers, so if the primary fails, one gets promoted and the other must be repointed.)
Sent from my iPad
Well, it depends on whether or not you need the file.
It's renamed so the system doesn't accidentally try to re-enter recovery mode.
However if you're still planning on having a standby, you _will_ need a recovery.conf file, and that's what this is, just renamed.
After successfully testing a failover between my primary and a standby server, the old recovery.conf file is renamed recovery.done. As this system is now the master, I don't see a
need to keep that file around, but is it safe to remove it now?
--
Jay
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin