[pgpool-general: 4408] Re: pgpool only write on backend 0
Tatsuo Ishii
ishii at postgresql.org
Sat Feb 6 00:13:01 JST 2016
> 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)
>From pgpool's point of view, "node 0 is down" no matter how you tweak
pgpool.conf.
>
> pg pool is running on node 0
That doesn't affect. Pgpool just thinks "PostgreSQL on node 0 is
unusable".
Best regards,
--
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-general
mailing list