[pgpool-general: 6309] Standby node's status is "down" when running "show pool_nodes" command
Mike Yeap
wkk1020 at gmail.com
Fri Nov 23 19:13:47 JST 2018
Hi, I'm new to Pgpool-II and trying a setup based on a two nodes streaming
replication configuration. But the "show pool_nodes" command shows a "down"
status for the standby node:
[postgres at hoopa-uat-1 log]$ psql -h hoopa-uat-pgpool-1 -p 9999 -U postgres
-c "show pool_nodes" postgres
node_id | hostname | port | status | lb_weight | role | select_cnt |
load_balance_node | replication_delay | last_status_change
---------+-------------+------+--------+-----------+---------+------------+-------------------+-------------------+--------------------
0 | hoopa-uat-1 | 5432 | up | 0.500000 | primary | 0 |
true | 0 | 2018-11-23 17:57:16
1 | hoopa-uat-2 | 5432 | down | 0.500000 | standby | 0 |
false | 0 | 2018-11-23 17:57:16
Actually the standby node is up, and I can run queries on it.
Can someone please enlighten me?
pgpool-II version 4.0.1
PostgreSQL version 11.1
Thank you.
Regards,
Mike Yeap
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20181123/cffe63d8/attachment.htm>
More information about the pgpool-general
mailing list