Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)

Поиск
Список
Период
Сортировка
От Devrim GÜNDÜZ
Тема Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
Дата
Msg-id 1188767335.2763.95.camel@laptop.gunduz.org
обсуждение исходный текст
Ответ на Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)  (Darek Czarkowski <dczarkowski@infinitesource.ca>)
Список pgsql-general
Hi,

On Fri, 2007-08-31 at 18:11 -0700, Darek Czarkowski wrote:
> when I try to increase number of connections to 200 I get
> "IpcSemaphoreCreate: semget(key=5432120, num=17, 03600) failed: No
> space left on device" Error
>
> Now, I dont think the default system settings are too low, default
> settings for semafores are kernel.sem = 250 32000 100 128

You should increase shmmax. Add this to sysctl.conf:

kernel.shmmax=$TheValueYouNeed

(and then run sysctl -p)

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/



Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Rodrigo De León"
Дата:
Сообщение: Re: return 1 formatted result instead of multiple results
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Timezone - UTC