Skip site navigation (1) Skip section navigation (2)

Re: too many clients. Can they wait in line?

From: "Peter Michaux" <petermichaux(at)gmail(dot)com>
To: "Dave Cramer" <pg(at)fastcrypt(dot)com>
Cc: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: too many clients. Can they wait in line?
Date: 2008-03-09 18:08:54
Message-ID: 3cbaf1c80803091108k209a5735gf933f0d7f993116f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Sun, Mar 9, 2008 at 4:38 AM, Dave Cramer <pg(at)fastcrypt(dot)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

In response to

pgsql-jdbc by date

Next:From: Marc HorvathDate: 2008-03-14 11:32:48
Subject: Blobs
Previous:From: Dave CramerDate: 2008-03-09 12:38:26
Subject: Re: too many clients. Can they wait in line?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group