Postgres Pro
Downloads
Home   >   mailing lists

Failover of a Hot standby setup with multiple standbys - Mailing list pgsql-admin

From Deepesh D
Subject Failover of a Hot standby setup with multiple standbys
Date
Msg-id CAJLzOySZtz=xzzuyke9BOyzUGOQ8AG=c7-0D6s92ZkJWsGLuqQ@mail.gmail.com
Whole thread Raw
Responses Re: Failover of a Hot standby setup with multiple standbys  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Lennin Caro
Date:
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Next
From: Greg Smith
Date:
Subject: Re: Monitor without superuser?