[pgpool-general: 4405] Re: pgpool only write on backend 0

[Tatsuo Ishii]

> postgres=# show pool_nodes;
>  node_id |       hostname       | port | status | lb_weight |  role  |
> select_cnt
> ---------+----------------------+------+--------+-----------+--------+------------
>  0       | serv1.lesafrance.com | 5432 | 3      | 0.500000  | slave  | 0
>  1       | serv2.lesafrance.com | 5432 | 2      | 0.500000  | master | 0
> (2 lignes)
> 
> do you need pgpool.conf ?

pgpool-II recognizes that node 0 is down (status 3). That's the reason
why pgpool-II does not send "CRERATE DATABASE" to node 0.

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