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

[Tatsuo Ishii]

> 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