[pgpool-general: 7584] Re: pool_backend_status

[Wolf Schwurack]

Never mind I figured out what I did wrong, when setting the configuration in pgpool.conf I copy the lines for backend_hostname1 , etc  for node 3 but didn’t change “1” to “2”

From: "pgpool-general-bounces at pgpool.net" <pgpool-general-bounces at pgpool.net> on behalf of Wolfgang Schwurack <wolf at uen.org>
Date: Tuesday, May 25, 2021 at 10:11 AM
To: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net>
Subject: [pgpool-general: 7583] pool_backend_status

I have 3 pgpool/postgresql nodes, When I run the command: show pool_backend_status or show pool_nodes, its only showing 2 out of the 3 nodes.
Shouldn’t I be seeing all 3 nodes?

OS = Ubuntu 20.0.1
PostgreSQL = 12.6
PgPool = 4.2.2


postgres=# show pool_backend_stats;

 node_id | hostname  | port | status |  role   | select_cnt | insert_cnt | update_cnt | delete_cnt | ddl_cnt | other_cnt | panic_cnt | fatal_cnt | error_cnt

---------+-----------+------+--------+---------+------------+------------+------------+------------+---------+-----------+-----------+-----------+-----------

 0       | pgtest-01 | 5432 | up     | primary | 14         | 0          | 0          | 0          | 0       | 14        | 0         | 0         | 0

 1       | pgtest-03 | 5433 | down   | standby | 0          | 0          | 0          | 0          | 0       | 0         | 0         | 0         | 0

(2 rows)


Wolf


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210525/383ebf6f/attachment.htm>