Re: Problem with postgreSQL (number of backends)

dev(at)archonet(dot)com ("Richard Huxton") wrote in
<20010424190204(dot)84D6D2A3AB(at)mainbox(dot)archonet(dot)com>:

>Konstantin Borchert <borchert(at)antsatwork(dot)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
>