Re: increasing max_connections on freebsd

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

In response to

Responses

Browse pgsql-general by date

  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.