Re: Increasing Max # of connections - Mailing list pgsql-general

From Nailah Ogeer
Subject Re: Increasing Max # of connections
Date
Msg-id Pine.SOL.4.33.0307231330110.10190-100000@innovate
Whole thread Raw
In response to Increasing Max # of connections  (Errol Neal <errol.neal@enhtech.com>)
List pgsql-general
the only way you can do this is to change your kernel parameters or use 32
connections and 64 buffers


On Wed, 23 Jul 2003, Errol Neal wrote:

> Hi All,
>
> I am using Postgresql 7.3.2 on Solaris 5.9 compiled with gcc and solaris
> ld. Right now, our max number of connections and buffers are set to the
> default, which is 32 for connections and 64 for buffers. I want to be able
> to increase that to 100 Max connections and 200 max buffers, but when I do
> that.. i get this:
>
> IpcSemaphoreCreate: semget(key=5432004, num=17, 03600) failed: No space
> left on device
>
> This error does *not* mean that you have run out of disk space.
>
> It occurs when either the system limit for the maximum number of
> semaphore sets (SEMMNI), or the system wide maximum number of
> semaphores (SEMMNS), would be exceeded.  You need to raise the
> respective kernel parameter.  Alternatively, reduce PostgreSQL's
> consumption of semaphores by reducing its max_connections parameter
> (currently 100).
>
> How do I increase the mentioned kernel values on solaris to be able to
> increase the number of connections I need?
>
>
> TIA,
>
>
> Errol U. Neal
>
>
> Errol Neal, Systems/Network Administrator
> eneal@enhtech.com
> Enhanced Technologies Inc.
> http://www.enhtech.com
> 703-924-0301 or 800-368-3249
> 703-924-0302 Fax
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


pgsql-general by date:

Previous
From: "Reuben D. Budiardja"
Date:
Subject: Re: New Poll @ Codewalkers
Next
From: "shuai@objectwareinc.com"
Date:
Subject: Convert TimeStamp to Date