Re: increasing max_connections on freebsd - Mailing list pgsql-general

From Christian Kratzer
Subject Re: increasing max_connections on freebsd
Date
Msg-id 20041214183103.C86706@vesihiisi.cksoft.de
Whole thread Raw
In response to Re: increasing max_connections on freebsd  (Michael Fuhr <mike@fuhr.org>)
Responses Re: increasing max_connections on freebsd
List pgsql-general
On Tue, 14 Dec 2004, Michael Fuhr wrote:

> On Tue, Dec 14, 2004 at 10:01:47AM -0500, Frank D. Engel, Jr. wrote:
[snipp]
> The error probably says something about not having enough shared
> memory or semaphores.  On FreeBSD some IPC settings can be configured
> via sysctl but others might need to be built into the kernel.  For
> example, on FreeBSD 4, trying to set kern.ipc.semmni or kern.ipc.semmns
> with sysctl fails, saying that the OID is read-only.

At least on FreeBSD 5.x there is no need to build a customer kernel.
The following can be set in /boot/loader.conf

     # defaults for FreeBSD are as follows
     # SEMMNI=10, # of semaphore identifiers
     # SEMMNS=60, # of semaphores in system
     # SEMUME=10, max # of undo entries per process
     # SEMMNU=30, # of undo structures in system
     kern.ipc.semmni=40
     kern.ipc.semmns=240
     kern.ipc.semume=40
     kern.ipc.semmnu=120

these will be set on boot.

Greetings
Christian

--
Christian Kratzer                       ck@cksoft.de
CK Software GmbH                        http://www.cksoft.de/
Phone: +49 7452 889 135                 Fax: +49 7452 889 136

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Insufficient memory for this operation.
Next
From: "Kall, Bruce A."
Date:
Subject: Copy row from table to table