I have already setup 2 ubuntu server 12.04 LTS on my local machine using virtual box and is using the master-slave replication (postgresql 9.1).
- 192.168.0.109 = master
- 192.168.0.110 = slave
my question is how to apply the load-balancing based on the two database server? I've heard about pgpool2 and pgbouncer, which one should I use?
Thanks guys and sorry I am new to postgres replication.