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

[Tatsuo Ishii]

> On 05/02/2016 15:25, Tatsuo Ishii wrote:
>>> 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
> I was just doing it ;)
> 
> 2016-02-05 15:31:11: pid 12344: LOG:  statement: CREATE database essai;
> 2016-02-05 15:31:11: pid 12344: LOG:  DB node id: 1 backend pid: 12349
> statement: CREATE database essai;
> 
> postgres=# CREATE database essai;
> CREATE DATABASE

Strange. Can you show me the result of "show pool_nodes"?

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