Re: Problem with postgreSQL (number of backends)

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Problem with postgreSQL (number of backends)
Дата
Msg-id 20010424190204.84D6D2A3AB@mainbox.archonet.com
обсуждение исходный текст
Ответ на Problem with postgreSQL (number of backends)  (borchert@antsatwork.de (Konstantin Borchert))
Список pgsql-general
Konstantin Borchert <borchert@antsatwork.de> said:

> Hi,
>
> i have problems with PostgreSQL 7.0.3 on a RedHat 6.2 System. Very often
> postgresql post me the following warning and error message.
>
>
> Warning: Unable to connect to PostgreSQL server: Sorry, too many clients
> already in /home/server/...
> PostgreSQL said: Unable to connect to server
>
>
> It seems to be a problem with buffers and backends. So i have restart the
> postmaster with the parameters "/usr/bin/postmaster -N 256 -B 512 " ... (i
> put these parameters in the file "postmaster.opts" in the postgresql data
> folder).But it seems to have no effect. The problem still exist.

How many clients do you have when this happens?
How much RAM have you got?
Did you alter the max_connections setting at install time?

- Richard Huxton

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

Предыдущее
От:
Дата:
Сообщение: Question on Bizarre Sorting (ORDER BY in 7.1)
Следующее
От: "Richard Huxton"
Дата:
Сообщение: Re: IBM to buy Informix