Thread: too many clients. Can they wait in line?
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? Thanks, Peter
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. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
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 Dave > > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc
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