Re: Problem with postgreSQL (number of backends) - Mailing list pgsql-general

From Richard Huxton
Subject Re: Problem with postgreSQL (number of backends)
Date
Msg-id 20010424190204.84D6D2A3AB@mainbox.archonet.com
Whole thread Raw
In response to Problem with postgreSQL (number of backends)  (borchert@antsatwork.de (Konstantin Borchert))
List 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 by date:

Previous
From:
Date:
Subject: Question on Bizarre Sorting (ORDER BY in 7.1)
Next
From: "Richard Huxton"
Date:
Subject: Re: IBM to buy Informix