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

[webgourou]

On 05/02/2016 15:54, Tatsuo Ishii wrote:
>> 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
Look I just switch backend and the result of show pool_nodes is switched too
postgres=# show pool_nodes
;
 node_id |       hostname       | port | status | lb_weight |  role  |
select_cnt
---------+----------------------+------+--------+-----------+--------+------------
 0       | serv2.lesafrance.com | 5432 | 3      | 0.500000  | slave  | 0
 1       | serv1.lesafrance.com | 5432 | 2      | 0.500000  | master | 0
(2 lignes)


pg pool is running on node 0