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

[Tatsuo Ishii]

> 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.

Works for me.

Can you set:

log_per_node_statement = on

in pgpool.conf, execute CREATE DATABASE and send the pgpool log?

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