[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.sraoss.jp/pipermail/pgpool-general/attachments/20181123/cffe63d8/attachment.html>


More information about the pgpool-general mailing list