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@xxxxxxxxxxx> 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@xxxxxxxxx[10:41]~/pgsql/HEAD:58%ipcs -a|grep decibel decibel@xxxxxxxxx[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@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
