From: | Nailah Ogeer <ogeer(at)cs(dot)queensu(dot)ca> |
---|---|
To: | Errol Neal <errol(dot)neal(at)enhtech(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Increasing Max # of connections |
Date: | 2003-07-23 17:31:03 |
Message-ID: | Pine.SOL.4.33.0307231330110.10190-100000@innovate |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)enhtech(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | shuai@objectwareinc.com | 2003-07-23 17:36:52 | Convert TimeStamp to Date |
Previous Message | Reuben D. Budiardja | 2003-07-23 17:28:48 | Re: New Poll @ Codewalkers |