Re: could not create shared memory segment: Invalid argument

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Ryan King - NOAA Affiliate <ryan(dot)king(at)noaa(dot)gov>
Cc: Scott Whitney <scott(at)journyx(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: could not create shared memory segment: Invalid argument
Date: 2015-07-14 00:43:18
Message-ID: 9CBF373D-FFB2-4094-8316-176B1D4F936D@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-performance

On Jul 13, 2015, at 6:26 PM, Ryan King - NOAA Affiliate <ryan(dot)king(at)noaa(dot)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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ryan King - NOAA Affiliate 2015-07-14 00:49:59 Re: could not create shared memory segment: Invalid argument
Previous Message Ryan King - NOAA Affiliate 2015-07-14 00:26:53 Re: could not create shared memory segment: Invalid argument

Browse pgsql-general by date

  From Date Subject
Next Message Ryan King - NOAA Affiliate 2015-07-14 00:49:59 Re: could not create shared memory segment: Invalid argument
Previous Message Ryan King - NOAA Affiliate 2015-07-14 00:26:53 Re: could not create shared memory segment: Invalid argument

Browse pgsql-performance by date

  From Date Subject
Next Message Ryan King - NOAA Affiliate 2015-07-14 00:49:59 Re: could not create shared memory segment: Invalid argument
Previous Message Ryan King - NOAA Affiliate 2015-07-14 00:26:53 Re: could not create shared memory segment: Invalid argument