[Pgpool-general] Question about Online Recovery

[DM]

Its my mistake sorry for misleading, (its not primary and standby) its
master- master (active-active).

Q:The primary goes down. The secondary takes over and starts WAL shipping to
the old primary right?
A: I dont think there is any WAL shipping done by pgpool,
Recovery is done basically using the command pcp_recovery_node
If node1 is down, on executing the command pcp_recovery_node, node 2 data is
copied to node 1 and node 1 and 2 is reconnected to pgpool.
Q:What happens when the old one comes back up? How does it know it's now the
secondary and should go into single user apply WAL logs mode?
Both nodes are active.

Q:Is is possible for pgpool to act as a witness and tell the systems which
one is the primary and which one is the secondary?
Wait for experts to answer the question.

Hopefully i answered your questions, experts correct me if i am wrong.

Thanks
Deepak
On Tue, Apr 7, 2009 at 2:47 PM, Tim Uckun <timuckun at gmail.com> wrote:

>
>> Assuming you have 2 systems one primary and another standby, in real time
>> scenario any system can go down. Its better to enable WAL on both system so
>> that if one fails you could recover from other.
>>
>
>
> Am I understanding this correctly?
>
> The primary goes down. The secondary takes over and starts WAL shipping to
> the old primary right?
>
> What happens when the old one comes back up? How does it know it's now the
> secondary and should go into single user apply WAL logs mode?
>
> How do you make it the primary again? Do you just shut down the secondary?
> I guess if the system was smart enough that's all it would take right?
>
> Is is possible for pgpool to act as a witness and tell the systems which
> one is the primary and which one is the secondary?
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090407/06b3aed0/attachment.html