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

[Tatsuo Ishii]

Thank you for the report!

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

> 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
>>