[Pgpool-general] Question about Online Recovery

[Tim Uckun]

>
>
> 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/20090408/663f1175/attachment.html