Gavin Kistner <phrogz@xxxxxxx> 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 kern.sysv.shmmax=33554432 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=8192 and PG starts fine for me. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
