Failover of a Hot standby setup with multiple standbys

From: Deepesh D <deep(dot)d2010(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Failover of a Hot standby setup with multiple standbys
Date: 2012-02-28 12:05:27
Message-ID: CAJLzOySZtz=xzzuyke9BOyzUGOQ8AG=c7-0D6s92ZkJWsGLuqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

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?

Please help.

Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Smith 2012-02-28 16:44:04 Re: Monitor without superuser?
Previous Message Lennin Caro 2012-02-27 14:33:35 Re: Automatic Failover Hot Standby / Streaming replication