I have setup PostgreSQL (9.1.2) in Hot standby mode on 4 linux servers (1
master - M and 3 standby - S1, S2, S3). I have a few doubts regarding how
the failover will be done in this setup.
Suppose if the master server fails and I make one of the standby (S1) the
master, how do I switch the other two standbys to the new master S1?
Is it enough if I just change the 'primary_conninfo' and 'restore_command'
in both the slaves (S2,S3) to point to the new master S1?
pgsql-admin by date
|Next:||From: Greg Smith||Date: 2012-02-28 16:44:04|
|Subject: Re: Monitor without superuser?|
|Previous:||From: Lennin Caro||Date: 2012-02-27 14:33:35|
|Subject: Re: Automatic Failover Hot Standby / Streaming replication|