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

[Tatsuo Ishii]

> Hi,
> 
> I’m migrating my Database cluster to PostgreSQL 14 and have been trying PGPOOL for the Load Balancer feature only.
> 
> At the moment I have two servers, and even though PGPOOL and Postgres are up and running on both of them, “show pool_nodes” shows as one of them being down.

[snip]

Which version of Pgpool-II is this?

Can you share pgpool log upon starting up?

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.

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