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

Поиск
Список
Период
Сортировка
От Darek Czarkowski
Тема Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
Дата
Msg-id 1188609062530095500@infinitesource.ca
обсуждение исходный текст
Ответы Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)  (Devrim GÜNDÜZ <devrim@CommandPrompt.com>)
Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

I am have installed postgresql-7.3.4 on Linux server running Red Hat Enterprise Linux Server release 5 (Tikanga).
Postmaster runs fine with the default settings, but 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
100128 
I have tried changing them, but I am not getting any results.

This is a new server, with almost twice the parameters of the older systems I have already running PostgresSQL for
years.The settings that I would use normally are: 

max_connections = 200
shared_buffers = 2048
sort_mem = 32168

That just doesn't seam possible on this new server. Any ideas?

P.S.
I can not use newer versions of PostgresSQL.

--
Darek Czarkowski


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

Предыдущее
От: "Manchenahalli, Raghunandan (STSD)"
Дата:
Сообщение: Timezone - UTC
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: WAL to RAW devices ?