Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS) - Mailing list pgsql-general

From Devrim GÜNDÜZ
Subject Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
Date
Msg-id 1188767335.2763.95.camel@laptop.gunduz.org
Whole thread Raw
In response to Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)  (Darek Czarkowski <dczarkowski@infinitesource.ca>)
List pgsql-general
Hi,

On Fri, 2007-08-31 at 18:11 -0700, Darek Czarkowski wrote:
> 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

You should increase shmmax. Add this to sysctl.conf:

kernel.shmmax=$TheValueYouNeed

(and then run sysctl -p)

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/



Attachment

pgsql-general by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: return 1 formatted result instead of multiple results
Next
From: Tom Lane
Date:
Subject: Re: Timezone - UTC