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