Re: Patroni vs pgpool II - Mailing list pgsql-general

From Nikolay Samokhvalov
Subject Re: Patroni vs pgpool II
Date
Msg-id CANNMO+LcFb_8hfDKYfPyROuEoZtbeM5X7JtGsAwP27NYonEt=w@mail.gmail.com
Whole thread Raw
In response to Re: Patroni vs pgpool II  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: Patroni vs pgpool II
List pgsql-general
On Thu, Apr 6, 2023 at 9:17 PM Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
> With quorum failover is enabled, w0, w1, and w2 communicate each other
> to vote who is correct (if it cannot communicate, it regards other
> watchdog is down). In the case above w0 and w1 are majority and will
> win.

Communication takes time – network latencies. What if during this
communication, the situation becomes different?

What if some of them cannot communicate with each other due to network issues?

What if pg1 is currently primary, pg0 is standby, both are healthy, but
due not network issues, both pg1 and w2 are not reachable to other
nodes? Will pg1 remain primary, and w0 and w1 decide to promote pg0?



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Patroni vs pgpool II
Next
From: Tatsuo Ishii
Date:
Subject: Re: Patroni vs pgpool II