[pgpool-general: 8019] Re: Pool Nodes are shown as down even if PG and PGPOOL are up
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: 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.
SRA OSS, Inc. Japan
More information about the pgpool-general