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?