[Pgpool-hackers] Enhancing show pool_nodes

[Tatsuo Ishii]

Currently show pool_nodes SQL command shows:

  id  |  hostname   | port | status | lb_weight

I would like to add info whether the node is primary, master or
standby because there's no way to know from exisiting pgpool-II UI.
The new column name would be "class" (plese say no, if you have better
idea about naming). The value will as follows:

Raw mode:
"master" or ""

Native replication mode:
"master" or "slave"

Streaming replication mode:
"primary" or "standby"

Master slave mode with slony:
"master" or "slave"

Comments or opinions?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp