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