pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSorry, to many clients already
3+ messages / 3 participants
[nested] [flat]
* Sorry, to many clients already
@ 2003-01-06 14:12 cristi <cristi@dmhi.ct.ro>
0 siblings, 1 reply; 3+ messages in thread
From: cristi @ 2003-01-06 14:12 UTC (permalink / raw)
To: pgsql-sql
When I'm trying to connect I have this error message:
Something unusual has occured to cause the driver to fail.Please report this
exception: java.sql.SQLException: Sorry, to many clients already.
What should I do?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Sorry, to many clients already
@ 2003-01-06 18:20 Robert Treat <xzilla@users.sourceforge.net>
parent: cristi <cristi@dmhi.ct.ro>
0 siblings, 0 replies; 3+ messages in thread
From: Robert Treat @ 2003-01-06 18:20 UTC (permalink / raw)
To: cristi <cristi@dmhi.ct.ro>; +Cc: pgsql-sql
On Mon, 2003-01-06 at 09:12, cristi wrote:
> When I'm trying to connect I have this error message:
>
> Something unusual has occured to cause the driver to fail.Please report this
> exception: java.sql.SQLException: Sorry, to many clients already.
>
>
> What should I do?
>
I might suggest posting to the -jdbc list in case this is something
different, but generally speaking the "too many clients" error means
that your application is attempting to connect to the db and the db is
responding that it already has created the maximum number of connections
that are allowed. This might be an indication of other problems, but if
you simply want to raise the limit you'll need to modify max_connections
in the postgresql.conf
Robert Treat
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Sorry, to many clients already
@ 2003-01-07 08:46 Tambet Matiisen <t.matiisen@aprote.ee>
0 siblings, 0 replies; 3+ messages in thread
From: Tambet Matiisen @ 2003-01-07 08:46 UTC (permalink / raw)
To: pgsql-sql
>
> When I'm trying to connect I have this error message:
>
> Something unusual has occured to cause the driver to
> fail.Please report this
> exception: java.sql.SQLException: Sorry, to many clients already.
>
I also met this error yesterday. Default PostgreSQL limit for incoming connections is 32 (actually 30 for ordinary users, because 2 are reserved for superusers). You can change this from postgresql.conf.
In our case the problem was pgAdmin, which creates a new connection for every database you click on. You can use `ps ax | grep postgres` in Linux to see active connections.
Tambet
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-01-07 08:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-06 14:12 Sorry, to many clients already cristi <cristi@dmhi.ct.ro>
2003-01-06 18:20 ` Robert Treat <xzilla@users.sourceforge.net>
2003-01-07 08:46 Re: Sorry, to many clients already Tambet Matiisen <t.matiisen@aprote.ee>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox