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
_______________________________________________
Pgpool-hackers mailing list
Pgpool-hackers@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-hackers

Reply via email to