We have system(Cluster) with Master replicating to 2 stand by servers.
i.e
M |--- S1
|--- S2
If master failed, we do a trigger file at S1 to take over as master. Now we
need to re-point the standby S2 as slave for the new master (i.e S1)
While trying to start standby
On Tue, Aug 2, 2011 at 12:59 AM, senthilnathan
senthilnatha...@gmail.com wrote:
We have system(Cluster) with Master replicating to 2 stand by servers.
i.e
M |--- S1
|--- S2
If master failed, we do a trigger file at S1 to take over as master. Now we
need to re-point the
On Tue, Aug 2, 2011 at 2:55 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Tue, Aug 2, 2011 at 12:59 AM, senthilnathan
senthilnatha...@gmail.com wrote:
We have system(Cluster) with Master replicating to 2 stand by servers.
i.e
M |--- S1
|--- S2
If master failed, we do a
?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Simon Riggs
Sent: Tuesday, August 02, 2011 12:07 PM
To: Merlin Moncure
Cc: senthilnathan; pgsql-general
Subject: Re: [GENERAL] Timeline Conflict
On Tue, Aug 2, 2011 at 2:55 PM, Merlin
On Tue, Aug 2, 2011 at 2:17 PM, Pedro Sam pe...@rim.com wrote:
I've been trying to use repmgr for just that purpose. Looks like it simply
creates/modifies a recovery.conf pointing primary_conninfo to the new master,
and then restart. It does not seem to have the ability to resolve any
On Tue, Aug 2, 2011 at 8:17 PM, Pedro Sam pe...@rim.com wrote:
I've been trying to use repmgr for just that purpose. Looks like it simply
creates/modifies a recovery.conf pointing primary_conninfo to the new master,
and then restart. It does not seem to have the ability to resolve any
On Tue, Aug 2, 2011 at 8:41 PM, Merlin Moncure mmonc...@gmail.com wrote:
Basically this is formalizing good practice for failing over nodes and
re-syncing to a promoted master. I will say though that one
unfortunate side effect of using HS/SR for HA is that you need *four*
servers to really
On Tue, Aug 2, 2011 at 2:59 PM, senthilnathan senthilnatha...@gmail.com wrote:
We have system(Cluster) with Master replicating to 2 stand by servers.
i.e
M |--- S1
|--- S2
If master failed, we do a trigger file at S1 to take over as master. Now we
need to re-point the
On Wed, Aug 3, 2011 at 2:38 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Tue, Aug 2, 2011 at 2:59 PM, senthilnathan senthilnatha...@gmail.com
wrote:
We have system(Cluster) with Master replicating to 2 stand by servers.
i.e
M |--- S1
|--- S2
If master failed, we do a