[pgpool-general: 7063] show pool_nodes

[Wolf Schwurack]

I have 3 Pgpool/PostgreSQL nodes. When I run the command below I only get 2 nodes showing.
Is this correct or should I be seeing all 3 nodes?


psql -h wd-pgtest -p 9999 -U repmgr -d repmgrdb -c "show pool_nodes;"



 node_id | hostname  | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change

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

 0       | pgtest-01 | 5432 | up     | 0.500000  | primary | 947        | false             | 0                 |                   |                        | 2020-06-02 11:24:45

 1       | pgtest-02 | 5432 | up     | 0.500000  | standby | 321        | true              | 0                 |                   |                        | 2020-06-02 11:24:45

(2 rows)

Ubuntu 20.04
Pgpool-II version 4.1.1
PostgreSQL 12

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wolf at uen.org<mailto:wolf at uen.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200603/584fcf57/attachment.html>