Re: Problem with postgreSQL (number of backends)

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

>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?

no more than 32 clients

>How much RAM have you got?

the server has 256 MB RAM

>Did you alter the max_connections setting at install time?

no, i use the default values
it's possible to change the value of max_connections??


>
>- Richard Huxton
>

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

Предыдущее
От: Paul Tomblin
Дата:
Сообщение: Re: Re: BETWEEN clause
Следующее
От: Mark Lawrence
Дата:
Сообщение: [QUESTION]: Recovery of tables