[pgpool-general: 5593] "show pool_nodes" node state in version 3.6.4

[Shay Cohavi]

Hi,
I have upgraded pgpool from 3.4.3 to 3.6.4 and I can see the the "show
pool_nodes" nodes status has been changed from digits (0,1,2 and 3) to
up/down state.

the documentation is referring to the old node state (digits):

http://www.pgpool.net/docs/latest/en/html/sql-show-pool-nodes.html


is it changed to "up" and "down" only or can we invoke the old state
(represented by digits)?




[root at mgrdb-56 ~]# psql -h 192.168.15.56 -p 9999 -U postgres -c 'show
pool_nodes'
Password for user postgres:
 node_id |   hostname    | port | status | lb_weight |  role   | select_cnt
| load_balance_node | replication_delay
---------+---------------+------+--------+-----------+---------+------------+-------------------+-------------------
 0       | 192.168.15.55 | 5432 | up     | 0.500000  | primary | 0
 | true              | 0
 1       | 192.168.15.56 | 5432 | up     | 0.500000  | standby | 0
 | false             | 0

[root at mgrdb-56 ~]# pcp_node_info -h 192.168.15.56 -p 9898 -U postgres 0
Password:
192.168.15.55 5432 2 0.500000 up


thanks,
cohavisi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20170626/97fa0e8d/attachment.htm>