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

[Tatsuo Ishii]

> 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

Really? I see below on the URL:

test=# show pool_nodes;
 node_id | hostname | port  | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay
---------+----------+-------+--------+-----------+---------+------------+-------------------+-------------------
 0       | /tmp     | 11002 | up     | 0.500000  | primary | 0          | false             | 0
 1       | /tmp     | 11003 | up     | 0.500000  | standby | 0          | true              | 0
(2 rows)

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

No, they are changed to:

old digit    new state representation
-------------------------------------
0           unnused
1           waiting
2           up
3           down

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp