Howdy all, I have some apps that are connecting to my DB via direct JDBC and I'd like to pool their connections.
I've been looking at poolers for a while, and pgbouncer and pgpool-ii seem to be some of the most popular, so i've started with those. I'm setting up pgbouncer, and i've hit a bit of a snag. Hopefully someone can tell me if pgbouncer or pgpool are capable of this (and if so, how to do it) or alternatly a pooler that can... What I'd like to be able to do is this (not using pooler syntax, this is just a high level of what i want to achive) Say i set max pool size = 10 connections. and max # of pools = 5. That means that i should have 5 connections to my database covering 50 connections total. I can't really seem to make that work with pgbouncer without naming the pools separetly. (pool1 = dbname = a, pool2 = dbname =a) which means my app is tied to a pool (or has to specifically code to rotate pools...) which is not really desireable. is what i'm looking to do possible in pgbouncer or pgpool? or anything? Thanks Dave -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
