[pgpool-general: 8013] Re: Pool Nodes are shown as down even if PG and PGPOOL are up
ishii at sraoss.co.jp
Sat Feb 5 09:45:50 JST 2022
> 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.
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.
SRA OSS, Inc. Japan
More information about the pgpool-general