Gavin Kistner <phrogz(at)mac(dot)com> writes:
> Mac OS X 10.6.3
> Built and installed PG 8.4.3 from source
> Trying to start the server, I get "could not create shared memory segment: Invalid argument".
OSX is *notoriously* unfriendly about configuring shm parameters.
You look at it sidewise, it doesn't work, and generally won't tell
you why it's refusing to talk to you. We document a few of the known
constraints in our manual, but I'm sure there are more.
> Slim2:pgsql _postgres$ sysctl -a | grep shm
> kern.sysv.shmmax: 2147483648
> kern.sysv.shmmin: 1
> kern.sysv.shmmni: 32
> kern.sysv.shmseg: 8
> kern.sysv.shmall: 2147483648
Hm. That shmall setting is not sane at all (remember the units are
pages). I wonder whether you've forced some internal overflow inside
the kernel. For comparison, I have these settings on my laptop:
pro:~ tgl$ cat /etc/sysctl.conf
and PG starts fine for me.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Gavin Kistner||Date: 2010-04-30 05:58:54|
|Subject: Re: Fresh build on OS X not working (memory)|
|Previous:||From: Gavin Kistner||Date: 2010-04-30 05:32:10|
|Subject: Fresh build on OS X not working (memory)|