[pgpool-general: 7584] Re: pool_backend_status
Wolf Schwurack
wolf at uen.org
Wed May 26 03:54:06 JST 2021
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>
More information about the pgpool-general
mailing list