[pgpool-hackers: 39] Add "role" to show pool_nodes command

Tatsuo Ishii ishii at postgresql.org
Sun Mar 4 11:25:08 JST 2012


Hi,

I have added "role" column to show pool_nodes command. Example output:

  id  |  hostname   | port | status | lb_weight |  role       
------+-------------+------+--------+-----------+---------
   0  | 127.0.0.1   | 5432 | 2      | 0.5       | primary
   1  | 192.168.1.7 | 5432 | 3      | 0.5       | standby

This should be useful especially operated in streaming replication mode.
--
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-hackers mailing list