Search Postgresql Archives

Re: Streaming replication failover process - Pgsql 9.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux