Re: could not create shared memory segment: Invalid argument

Поиск
Список
Период
Сортировка
От Ryan King - NOAA Affiliate
Тема Re: could not create shared memory segment: Invalid argument
Дата
Msg-id CAJAJqWHiO=0Ah429WPXX4c2W8at8W=1oy5ZRzPubFW=RA9BunQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: could not create shared memory segment: Invalid argument  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: could not create shared memory segment: Invalid argument  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Дерево обсуждения
Yeah thanks I see I was going the wrong way...thanks. 
So shared_buffers is 15gb and max_conn = 1000. 

However, after increasing, same issue. 

# Controls the maximum shared segment size, in bytes
#kernel.shmmax = 68719476736
kernel.shmmax = 268719476736

# Controls the maximum number of shared memory segments, in pages
#kernel.shmall = 4294967296
kernel.shmall = 4294967296

This should be plenty...

On Mon, Jul 13, 2015 at 7:43 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Jul 13, 2015, at 6:26 PM, Ryan King - NOAA Affiliate <ryan.king@noaa.gov> wrote:
>
> # Controls the maximum shared segment size, in bytes
> #kernel.shmmax = 68719476736 - orginal
> #kernel.shmmax = 16833540096
> kernel.shmmax = 168
>
> # Controls the maximum number of shared memory segments, in pages
> #kernel.shmall = 4294967296  - orginal
> kernel.shmall = 4109751

Wait, you need to be going *UP* on these. They need to be >= postgres's shared buffers + some minor other stuff.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice






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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: could not create shared memory segment: Invalid argument
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: could not create shared memory segment: Invalid argument