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

webgourou webgourou2000 at gmail.com
Fri Feb 5 23:04:50 JST 2016


On 05/02/2016 15:03, Tatsuo Ishii wrote:
>> hi,
>>
>> I just notice that with replication on and load_balance on
>> pgpool only on the backend0.
>>
>> Exemple:
>> # 1
>> backend0 = serv1
>> backend1 = serv2
>> #write on serv1
>>
>> # if switch
>> backend0 = serv2
>> backend1  = serv1
>> #write on serv2
>>
>> Any idea ?
> Actual query and pgpool-II version, please.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
Hello,

query "CREATE DATABASE toto"; user postgres
pgpool version 3.4.4 just change because it is the latest stable.

Thanks

Aurel


More information about the pgpool-general mailing list