Increasing Max # of connections

From: Errol Neal <errol(dot)neal(at)enhtech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Increasing Max # of connections
Date: 2003-07-23 15:48:53
Message-ID: 5.1.0.14.0.20030723114504.023dee48@mail.enhtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cory 'G' Watson 2003-07-23 15:56:12 Re: Increasing Max # of connections
Previous Message Shridhar Daithankar 2003-07-23 15:30:41 Re: 7.4dev or beta version