From: | Christian Kratzer <ck-lists(at)cksoft(dot)de> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | "Frank D(dot) Engel, Jr(dot)" <fde101(at)fjrhome(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: increasing max_connections on freebsd |
Date: | 2004-12-14 17:34:05 |
Message-ID: | 20041214183103.C86706@vesihiisi.cksoft.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)cksoft(dot)de
CK Software GmbH http://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
From | Date | Subject | |
---|---|---|---|
Next Message | Kall, Bruce A. | 2004-12-14 17:48:21 | Copy row from table to table |
Previous Message | Greg Stark | 2004-12-14 17:25:29 | Re: Insufficient memory for this operation. |