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 <[EMAIL PROTECTED]> 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...
[EMAIL PROTECTED]:41]~/pgsql/HEAD:58%ipcs -a|grep decibel
[EMAIL PROTECTED]: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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
