[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