Re: Fast promotion, loose ends

On 22.04.2013 18:44, Simon Riggs wrote:
> On 22 April 2013 09:29, Heikki Linnakangas<hlinnakangas@vmware.com>  wrote:
>
>> Hmm. That requires write access to $DATADIR, so that's not quite the same
>> thing as the trigger_file recovery.conf option.
>
> Well, you also (elsewhere) requested that we must keep recovery.conf
> in $DATADIR, so it needs to be writable.

That's a slightly different requirement. $DATADIR must be writable by 
the process that restores the backup or puts the server into standby 
mode, while trigger_file needs to be writable by the process that 
triggers failover. Those are not necessarily the same thing. I'm 
thinking of a heartbeat process that triggers failover by creating a 
file on an NFS server or similar. Possibly the same location where the 
WAL archive is located. $DATADIR would be stored elsewhere.

- Heikki