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

[Tatsuo Ishii]

> First of all, thank you for the release of pgpool-II!

You are welcome!

> 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