From: | Darek Czarkowski <dczarkowski(at)infinitesource(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS) |
Date: | 2007-09-01 01:11:02 |
Message-ID: | 1188609062530095500@infinitesource.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am have installed postgresql-7.3.4 on Linux server running Red Hat Enterprise Linux Server release 5 (Tikanga).
Postmaster runs fine with the default settings, but when I try to increase number of connections to 200 I get
"IpcSemaphoreCreate: semget(key=5432120, num=17, 03600) failed: No space left on device" Error
Now, I dont think the default system settings are too low, default settings for semafores are kernel.sem = 250 32000 100 128
I have tried changing them, but I am not getting any results.
This is a new server, with almost twice the parameters of the older systems I have already running PostgresSQL for years. The settings that I would use normally are:
max_connections = 200
shared_buffers = 2048
sort_mem = 32168
That just doesn't seam possible on this new server. Any ideas?
P.S.
I can not use newer versions of PostgresSQL.
--
Darek Czarkowski
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-09-01 01:11:52 | Re: Out of Memory - 8.2.4 |
Previous Message | Alex Vinogradovs | 2007-09-01 01:10:02 | Re: WAL to RAW devices ? |