Re: Increasing Max # of connections

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
>