[Pgpool-general] pgpool-II master/slave mode, BackendError

[Mikko Partio]

Tatsuo Ishii wrote:
>> I am planning to use pgpool-II in a master/slave configuration.
>>
>> However, I am unable to get it to work. I have the following settings in
>> pgpool.conf:
>>
>> replication_mode = false
>> ...
>> load_balance_mode = true
>> ...
>> master_slave_mode = true
>> ...
>> backend_hostname0 = 'localhost'
>> backend_port0 = 5432
>> backend_weight0 = 1
>> backend_hostname1 = 'localhost'
>> backend_port1 = 5433
>> backend_weight1 = 1
>>
>> Pgpool starts fine with those settings. However:
>>
>> ./pgpool2/bin/pcp_node_info 10 localhost 9898 jdavis jdavis 0
>> localhost 5432 1 1073741823.500000
>> ./pgpool2/bin/pcp_node_info 10 localhost 9898 jdavis jdavis 1
>> BackendError
>>
>> So, I get "BackendError" for node 1. If I connect to pgpool (port 9999)
>> it doesn't appear to use node 1 at all, but it appears to use node 0
>> just fine.
>>
>> However, if I set replication_mode=true and master_slave_mode=false,
>> both of the above commands succeed.
>>
>> Debug mode didn't give me much more info.
>>
>> Any help would be appreciated.
>>     
>
> I found a bug in master slave mode. pgpool-II accidently thinks that
> you have only one PostgreSQL server. I have committed fixes in
> CVS. Can you please try it out?
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>   

Hello,

I had the same BackendError-problem (only with two different hosts 
rather two database instances on the same host), but after patching it 
seems to be working just fine.

Mikko