Re: Streaming replication failover process - Pgsql 9.2

On 7/10/2016 2:19 PM, Patrick B wrote:
> 1. When the connection comes back, will the master and slave work as
> expected? The streaming replication should be ok?

as long as you have sufficient WAL available it should recover fine.
you might have to restart the slave to get it to reconnect.

>
> 2. As the master will be down, I don't wanna slave turns into a master
> by Failover. The trigger_file line on recovery.conf on the slave
> server is commented, so should be ok here right? The slave will be
> still a slave once master is down....
>

failover is a function of whatever cluster management software you use,
postgres won't failover on its own.

--
john r pierce, recycling bits in santa cruz