FATAL: Sorry, too many clients already????

From: Dan Miller <jitdsm(at)aol(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: FATAL: Sorry, too many clients already????
Date: 2005-06-10 05:18:42
Message-ID: d8b7ri$9d$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ilja Golshtein 2005-06-10 05:52:53 Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Previous Message go 2005-06-10 04:42:24 Wrong select results after transaction (HELP PLS)