FATAL: Sorry, too many clients already???? - Mailing list pgsql-general

From Dan Miller
Subject FATAL: Sorry, too many clients already????
Date
Msg-id d8b7ri$9d$1@news.hub.org
Whole thread Raw
Responses Re: FATAL: Sorry, too many clients already????
List pgsql-general
I have a server under very light load -- just me doing some work in php.
    I am getting this error often and don't know why:

postgresql max connections Unable to connect to PostgreSQL server:
FATAL: Sorry, too many clients already

my orignal postgresql.conf had:

      max_connections = 8
      shared_buffers = 16

I changed those to 32 and  64 and it is working so far.  But I have  a
bunch of postgresses running now with all of them doing almost nothing:

postgres 11747  0.0  0.0  8612 1904 ?        S    00:27   0:00 postgres:
stats buffer process
postgres 11778  0.0  0.0  7620 1928 ?        S    00:27   0:00 postgres:
stats collector process
postgres 12950  0.0  0.0  9132 4300 ?        S    00:27   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres 13152  0.0  0.0  8436 3748 ?        S    00:27   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres 13216  0.0  0.0  8436 3644 ?        S    00:27   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres 13410  0.0  0.0  8036 2952 ?        S    00:27   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres 13474  0.0  0.0  8436 3940 ?        S    00:27   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres 13664  0.0  0.0  8420 3796 ?        S    00:27   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres 13824  0.0  0.0  8040 3024 ?        S    00:27   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres 13890  0.0  0.0  8436 3984 ?        S    00:27   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres  2466  0.0  0.0  8432 3764 ?        S    00:31   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres  2535  0.0  0.0  8568 3960 ?        S    00:31   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle
postgres 19026  0.0  0.0  8040 2940 ?        S    01:11   0:00 postgres:
dcm1104_root mkim_org 127.0.0.1 idle

i have tried both pg_connect and pg_pconnect, and this happens either
way.  I don't understand why it keeps starting more processes when there
are others sitting around doing nothing???  Any thoughts?  I am
tired...Maybe I'm missing something obvious....

Thanks

Dan

pgsql-general by date:

Previous
From: "madhu aggarwal"
Date:
Subject: Problem in unicode sorting
Next
From: Edward Peschko
Date:
Subject: mirroring oracle database in pgsql