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
