| From: | "Tambet Matiisen" <t(dot)matiisen(at)aprote(dot)ee> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Sorry, to many clients already |
| Date: | 2003-01-07 08:46:36 |
| Message-ID: | 81132473206F3A46A72BD6116E1A06AE3EC013@black.aprote.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | alviN | 2003-01-07 10:46:39 | SQL list table names |
| Previous Message | Richard Rowell | 2003-01-07 03:58:35 | to_date confusion |