Postgres Pro
Downloads
Home   >   mailing lists

Re: could not create shared memory segment: Invalid argument - Mailing list pgsql-admin

From Scott Ribe
Subject Re: could not create shared memory segment: Invalid argument
Date
Msg-id 9CBF373D-FFB2-4094-8316-176B1D4F936D@elevated-dev.com
Whole thread Raw
In response to Re: could not create shared memory segment: Invalid argument  (Ryan King - NOAA Affiliate <ryan.king@noaa.gov>)
Responses Re: could not create shared memory segment: Invalid argument  (Ryan King - NOAA Affiliate <ryan.king@noaa.gov>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Ryan King - NOAA Affiliate
Date:
Subject: Re: could not create shared memory segment: Invalid argument
Next
From: Ryan King - NOAA Affiliate
Date:
Subject: Re: could not create shared memory segment: Invalid argument