[Pgpool-general] Sending all selects to secondary server

Michael Connors connorsml at gmail.com
Fri Dec 7 11:28:00 UTC 2007


Hi,
I am new to pgpool.
I have recently set up Slony replication for a database, with the idea that
I would use pgpool to send all update requests to the primary server and all
selects to the secondary server.

I set it up as follows:

load_balance_mode = true
weight_master = 0
weight_secondary = 1


However selects are still being sent to the master db.

Is this not the correct way to do this?
Regards,
-- 
Michael
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20071207/ad74b09d/attachment.html 


More information about the Pgpool-general mailing list