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