Re: increasing max_connections on freebsd
Christian Kratzer <ck-lists@cksoft.de>
From: Christian Kratzer <ck-lists@cksoft.de>
To: Michael Fuhr <mike@fuhr.org>
Cc: "Frank D. Engel, Jr." <fde101@fjrhome.net>, pgsql-general@postgresql.org
Date: 2004-12-14T17:34:05Z
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@cksoft.de CK Software GmbH http://www.cksoft.de/ Phone: +49 7452 889 135 Fax: +49 7452 889 136