[pgpool-hackers: 4384] Re: 3rd node in 3-node HA cluster not working when other two nodes go down

[Salman Ahmed]

Dear Tatsuo Ishii,

This issue has been resolved based on your suggestions in response to this
query of mine:  [pgpool-hackers: 4369] Load balancing after failover not
working in 3-node HA PostgreSQL cluster
<https://www.pgpool.net/pipermail/pgpool-hackers/2023-August/004370.html> .
Thankyou for your support.

Salman Ahmed
Stormatics

On Wed, Aug 16, 2023 at 2:15 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > Dear pgpool-hackers,
> >
> > We’re currently working on pg_cirrus - a simple tool to setup 3-node HA
> > PostgreSQL clusters using pgpool. We’re facing an issue i.e. after second
> > failover the third node stops responding.
> >
> > When pg_cirrus sets up 3-node HA cluster within the same subnet and the
> > primary node fails, a standby node is promoted as the new primary node
> and
> > client machines are able to connect with the cluster via pgpool. When
> this
> > newly promoted primary node also fails the third node stops responding.
> >
> >
> > Is this the expected behavior or are we doing something wrong, kindly
> guide
> > us.
>
> There are so many possibilities and I cannot guess the cause without
> knowing more information. Can you share:
>
> pgpool.conf
> pgpool log
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS LLC
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20230825/7bd26cd8/attachment.htm>