Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)

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

Responses

Browse pgsql-general by date

  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 ?