| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Horvath | 2008-03-14 11:32:48 | Blobs |
| Previous Message | Dave Cramer | 2008-03-09 12:38:26 | Re: too many clients. Can they wait in line? |