Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CA35B9F9DFE for ; Mon, 29 Oct 2007 10:40:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23815-10 for ; Mon, 29 Oct 2007 10:40:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 965609F9E6E for ; Mon, 29 Oct 2007 10:40:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l9TDeA2d004732; Mon, 29 Oct 2007 09:40:10 -0400 (EDT) To: Maximilian Tyrtania cc: "pgsql-admin@postgresql.org" Subject: Re: shared memory settings on MAC OS X In-reply-to: References: Comments: In-reply-to Maximilian Tyrtania message dated "Mon, 29 Oct 2007 10:13:45 +0100" Date: Mon, 29 Oct 2007 09:40:10 -0400 Message-ID: <4731.1193665210@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/286 X-Sequence-Number: 27200 Maximilian Tyrtania writes: > Tom, I suspect you have Mac OS X Server installed, right? That's probably > why your /etc/sysctl.conf file mentions that /etc/sysctl-macosxserver.conf > file, while mine doesn't. Uh, no, I'm looking at my laptop. Curious that yours has no reference to the other file. > And frankly, to me it looks as if it means "if there is a /etc/sysctl.conf > file, then read it and accept its settings. Then overwrite the sysctl > settings with the default values, no matter what." You're forgetting the point I made that the first complete set of shmem settings wins. If we could change the settings on the fly after that, all this would be a whole lot easier, but the OSX kernel locks them down somehow. BTW, I dunno if you read awk at all, but that awk command effectively says "print lines that contain = and do not contain #". You didn't try appending comments to the setting lines in your file did you? regards, tom lane