Re: could not create shared memory segment: Invalid argument

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(at)elevated-dev(dot)com>
wrote:

> 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
>
>
>
>
>
>