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
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 |