[pgpool-general: 8019] Re: Pool Nodes are shown as down even if PG and PGPOOL are up

Tatsuo Ishii ishii at sraoss.co.jp
Wed Feb 9 09:11:33 JST 2022

>> One thing I found weird is show pool_nodes shows "role" fields as
>> "slave" or "master". However I see:
>>> backend_clustering_mode = 'streaming_replication'
>> In this case the role field should be either "primary" or standby.
> Hmm... interesting!

You are using 4.1.4, which does not have backend_clustering_mode
parameter.  You mixed up 4.2 or higher pgpool configuration file and
4.1 pgpool configuration file?  Please check.

I also recommend you to update to more recent versin 4.1.x. 4.1.4 was
released 2 years ago.

BTW, there's the reason why node is down:
Feb  8 22:49:07 pgsql-awsbau-masterdb pgpool[1306560]: 2022-02-08 22:49:07: pid 1306560: LOG:  reading status file: 0 th backend is set to down status

The information (node 0 was down) is stored in
/var/log/postgresql/pgpool_status in your case (under logdir).  You
can safely remove the file and restart pgpool to make node 0 online.
The file will be automatically generated upon start up.

Best reagards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list