Re: Problem with postgreSQL (number of backends)

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