Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 86DEA632F76 for ; Fri, 30 Apr 2010 02:59:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 04207-04 for ; Fri, 30 Apr 2010 05:58:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from asmtpout029.mac.com (asmtpout029.mac.com [17.148.16.104]) by mail.postgresql.org (Postfix) with ESMTP id A0ABF632E41 for ; Fri, 30 Apr 2010 02:58:58 -0300 (ADT) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; charset=us-ascii Received: from [192.168.191.12] (bcn-204-144-179-235.mric.net [204.144.179.235]) by asmtp029.mac.com (Sun Java(tm) System Messaging Server 6.3-8.01 (built Dec 16 2008; 32bit)) with ESMTPSA id <0L1O003JNDY73X00@asmtp029.mac.com> for pgsql-admin@postgresql.org; Thu, 29 Apr 2010 22:58:57 -0700 (PDT) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx engine=5.0.0-0908210000 definitions=main-1004290288 Subject: Re: Fresh build on OS X not working (memory) From: Gavin Kistner In-reply-to: <15253.1272606140@sss.pgh.pa.us> Date: Thu, 29 Apr 2010 23:58:54 -0600 Cc: pgsql-admin@postgresql.org Message-id: References: <88181C2E-01CD-417C-8266-D5C9AF570C27@mac.com> <15253.1272606140@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.1078) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.609 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/361 X-Sequence-Number: 34455 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 the following 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