Re: Increasing Max # of connections
От | Nailah Ogeer |
---|---|
Тема | Re: Increasing Max # of connections |
Дата | |
Msg-id | Pine.SOL.4.33.0307231330110.10190-100000@innovate обсуждение исходный текст |
Ответ на | Increasing Max # of connections (Errol Neal <errol.neal@enhtech.com>) |
Список | 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 по дате отправления: