Re: shmget fails on OS X with proper settings - Mailing list pgsql-general

Just a final note:

Changing shmall did fix the problem. Thanks to everyone for the help.
the final working settings i used are:

kern.sysv.shmmax=4194304
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.sysv.shmall=4194304

I'm wondering how I managed to get it to work before, without setting shmall.

Thanks again to everyone

Thanks,
Chris

On 5/7/07, Jim Nasby <decibel@decibel.org> wrote:
> On May 7, 2007, at 9:11 AM, Tom Lane wrote:
> > I believe BTW that you
> > need to do "sudo ipcs -a" to be sure of seeing everything; otherwise
> > OS X's ipcs silently doesn't tell you about segments your userid
> > doesn't
> > have access to.
>
> Actually, it seems that you don't get anything back when ipcs is run
> as non-root...
>
> decibel@platter.1[10:41]~/pgsql/HEAD:58%ipcs -a|grep decibel
> decibel@platter.1[10:41]~/pgsql/HEAD:59%sudo ipcs -a|grep decibel
> m 3080191    5555001 --rw-------  decibel  decibel  decibel
> decibel      3 38133760  11042  11042  9:00:53 10:41:53  9:00:53
> --
> Jim Nasby                                            jim@nasby.net
> EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
>
>
>