On Sun, Mar 9, 2008 at 4:38 AM, Dave Cramer <pg@fastcrypt.com> wrote:
>
> On 9-Mar-08, at 5:02 AM, Heikki Linnakangas wrote:
>
> > Peter Michaux wrote:
> >> I'm using postgresql-8.2-506.jdbc3.jar with PostgreSQL 8.2.4 and I am
> >> seeing "FATAL: sorry, too many clients already". Can I somehow have
> >> these threads wait in line until a connection is available? Perhaps
> >> with some sort of timeout of 30 seconds?
> >
> > Try pgpool.
>
> Since this is a java application I'd suggest you use a java pool
> apache's dbcp
I tried dbcp and it seems to do the trick nicely.
Thanks,
Peter