Re: shmget fails on OS X with proper settings

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(at)decibel(dot)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(at)platter(dot)1[10:41]~/pgsql/HEAD:58%ipcs -a|grep decibel
> decibel(at)platter(dot)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(at)nasby(dot)net
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
>
>