Connection Pooling

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