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

From: Devrim GÜNDÜZ <devrim(at)CommandPrompt(dot)com>
To: Darek Czarkowski <dczarkowski(at)infinitesource(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
Date: 2007-09-02 21:08:55
Message-ID: 1188767335.2763.95.camel@laptop.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-02 22:50:47 Re: Timezone - UTC
Previous Message Rodrigo De León 2007-09-02 21:04:41 Re: return 1 formatted result instead of multiple results