Stuart, thanks for your reply. On 05/08/2014 12:47 AM, Stuart Bishop wrote: > recovery.conf goes into $DATADIR, which is > /var/lib/postgresql/9.1/main in your case. I rationalize this by > considering it database state, rather than configuration, since > commands like 'pg_ctl promote' or using a trigger file will mess with > it. Fair enough; let's change the file's extension and avoid confusion then... ;-) >> The problem is that recovery.conf gets ignored in this case. I can add >> another symlink pointing to it into the data directory, for example, or >> copy the file there, then it works, but honestly this has cost me a LOT >> of time figuring out. > > Having the two, with the master in /etc, will confuse you. And quite > possibly PostgreSQL if it needs to promote the database. OK, I will leave only one copy of recovery.conf in $DATADIR to avoid problems. Thanks, Stephan
