Re: increasing max_connections on freebsd

Поиск
Список
Период
Сортировка
От Christian Kratzer
Тема Re: increasing max_connections on freebsd
Дата
Msg-id 20041214183103.C86706@vesihiisi.cksoft.de
обсуждение исходный текст
Ответ на Re: increasing max_connections on freebsd  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: increasing max_connections on freebsd
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Insufficient memory for this operation.
Следующее
От: "Kall, Bruce A."
Дата:
Сообщение: Copy row from table to table