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

[Jeff Davis]

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

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.

Regards,
	Jeff Davis