On Thu, Jun 3, 2010 at 4:03 PM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > I'm interested in this too...does anyone else have experience in this matter? > I've pondered this many times. My questions are what failure mode are you looking to avoid, especially if you're using pgbouncer for load balance in addition to connection pool. I think the best spot in most cases is the web server itself, but If the web server is dead, then the pooler goes with it, whereas if the pooler is elsewhere you have yet another point of failure when load balancing -- that is if db1 goes down and takes pgpool with it, db2 is unused and won't save your app. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
