[pgpool-general: 5594] Re: "show pool_nodes" node state in version 3.6.4
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Jun 27 08:29:07 JST 2017
> 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
More information about the pgpool-general
mailing list