Re: Sorry, to many clients already

Поиск
Список
Период
Сортировка
От Tambet Matiisen
Тема Re: Sorry, to many clients already
Дата
Msg-id 81132473206F3A46A72BD6116E1A06AE3EC013@black.aprote.com
обсуждение исходный текст
Ответ на Sorry, to many clients already  ("cristi" <cristi@dmhi.ct.ro>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: Re: sub-select, view and sum()
Следующее
От: alviN
Дата:
Сообщение: SQL list table names