On Wed, Aug 3, 2011 at 2:38 AM, Fujii Masao wrote:
> On Tue, Aug 2, 2011 at 2:59 PM, senthilnathan
> 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 tak
On Tue, Aug 2, 2011 at 2:59 PM, senthilnathan 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 standby S2 as slav
On Tue, Aug 2, 2011 at 8:41 PM, Merlin Moncure 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 protect yoursel
On Tue, Aug 2, 2011 at 8:17 PM, Pedro Sam 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
> timeline conf
On Tue, Aug 2, 2011 at 2:17 PM, Pedro Sam 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
> timeline conf
ectly?
-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, M
On Tue, Aug 2, 2011 at 2:55 PM, Merlin Moncure wrote:
> On Tue, Aug 2, 2011 at 12:59 AM, senthilnathan
> 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
On Tue, Aug 2, 2011 at 12:59 AM, senthilnathan
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 standby S2 as sla
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 S2,the
