Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group