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

Tatsuo Ishii ishii at sraoss.co.jp
Sat Feb 5 09:45:50 JST 2022

> 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.


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

More information about the pgpool-general mailing list