Re: Fresh build on OS X not working (memory) - Mailing list pgsql-admin

From Gavin Kistner
Subject Re: Fresh build on OS X not working (memory)
Date
Msg-id BC88739D-8F46-4750-ADBA-C6F170EC412C@mac.com
Whole thread Raw
In response to Re: Fresh build on OS X not working (memory)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Fresh build on OS X not working (memory)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Apr 29, 2010, at 11:42 PM, Tom Lane wrote:
> 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.

I'm not sure what magic you have in there, but this incantation copied verbatim worked for me. Thanks!

The first sysctl.conf I tried that didn't work from from the one-click installer's README. Do you see anything about
thefollowing settings that jumps out at you as bad? Is it notable that yours don't set the maxproc*? 

kern.sysv.shmmax=1610612736
kern.sysv.shmall=393216
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.maxprocperuid=512
kern.maxproc=2048


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fresh build on OS X not working (memory)
Next
From: Péter Kovács
Date:
Subject: Querying the hostname of the server