[Pgpool-general] multiple slaves

Tomek Piatek tomek at projectx.co.nz
Wed Feb 22 21:25:57 GMT 2006


Hello,

This is what I'm trying to accomplish:

- Replication with Slony-I: single master, multiple slaves.
- Connection caching, pooling and load balancing with pgpool.

I've picked pgpool as the load balancing solution mainly for one  
reason: it says in the docs that in master/slave mode writes/updates  
go to the master and selects go to the slaves. This is very important  
to me because I don't want to have to modify my application to make  
it aware of the difference between master db and slaves.

My questions is this: how do I configure pgpool to make it aware that  
I have multiple slaves?

This is not very well documented so any help with this will be  
greatly appreciated.

cheers,
tomek



More information about the Pgpool-general mailing list