[Pgpool-general] Master/Slave Load Balancing Configuration

[Ow Mun Heng]

Setup : 
Slony 1 master, 1 slave - pg8.2.5, slony 1.12
pgpool - 2.01
OS : centos 4
Goal : SLony for replication
Pgpool for load balancing across multiple slaves+1master


configuration used which "works" but not as advertised on the
readme/webpage


listen_addresses = '*'
port = 9999
replication_mode = true
load_balance_mode = true
master_slave_mode = true
ignore_leading_white_space = true
backend_host_name = 'pgmaster'
backend_port = 5432
weight_master = 0.2
secondary_backend_host_name = 'pgslave1'
secondary_backend_port = 5432
weight_secondary = 0.8



If I were to use replication_mode = false (as in the docs) then all the
select queries will only hit the master DB and there's no note on the
debug logs saying "load balance on 1", "load balance on 0" or something
like that.

I've tried to use

backend_hostname0
backend_hostname1
backend_port0
backend_port1
etc also to no avail.

I don't have pcp_* command as it's not included in the rpms

I've googled and search through a _lot_ of archives and lists but found
no clue as to what is happening.

Would really appreciate some help help..


As of right now, the working config will give me 1 master + 1 slave in
load balance mode and ONLY if I put in replication_mode = true

Thanks.