[pgpool-general: 8715] How does pgpool handle the due-failure problem?

[Zhaoxun Yan]

Suppose we have two servers, under extreme circumstances two may both fail.
Now that we face 4 possibilities:

1) Master fail -> Standby self-promote -> Standby fail -> old Master
recover ?
2) Master fail -> Standby self-promote -> Standby fail -> Standby and new
Master recover?
3) Standby fail -> Master fail -> Standby Recover?
4) Standby fail -> Master fail -> Master recover?

1 and 3 are especially hazardous because the only recovered server may view
itself as the current master and hence lose data during its failure time. I
believe when only one server wakes up it should stay and wait for the other
server to recover before negotiating who should be the new master.

Does pgpool have such a mechanism?

Regards,
  Zhaoxun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230404/fc9d06cc/attachment.htm>