Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C05A29F9487 for ; Mon, 29 Oct 2007 10:55:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 51410-08 for ; Mon, 29 Oct 2007 10:55:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fischerappelt.de (mail.fischerappelt.de [217.110.127.211]) by postgresql.org (Postfix) with ESMTP id 1DC609F9376 for ; Mon, 29 Oct 2007 10:55:36 -0300 (ADT) Received: from [217.110.127.209] (account mty HELO [192.168.111.194]) by fischerappelt.de (CommuniGate Pro SMTP 5.1.7) with ESMTPA id 5508009; Mon, 29 Oct 2007 14:55:35 +0100 User-Agent: Microsoft-Entourage/11.3.6.070618 Date: Mon, 29 Oct 2007 14:55:33 +0100 Subject: Re: shared memory settings on MAC OS X From: Maximilian Tyrtania To: Tom Lane CC: "pgsql-admin@postgresql.org" Message-ID: Thread-Topic: [ADMIN] shared memory settings on MAC OS X Thread-Index: AcgaM1+fnhv+Y4YmEdyCKgAX8gNwZg== In-Reply-To: <4731.1193665210@sss.pgh.pa.us> Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.406 tagged_above=0 required=5 tests=AWL=0.405, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200710/287 X-Sequence-Number: 27201 > Von: Tom Lane > Datum: Mon, 29 Oct 2007 09:40:10 -0400 >> Tom, I suspect you have Mac OS X Server installed, right? That's probabl= y >> why your /etc/sysctl.conf file mentions that /etc/sysctl-macosxserver.co= nf >> file, while mine doesn't. >=20 > Uh, no, I'm looking at my laptop. Curious that yours has no reference > to the other file. Indeed. Good to hear you are using a Mac, though. >> And frankly, to me it looks as if it means "if there is a /etc/sysctl.co= nf >> file, then read it and accept its settings. Then overwrite the sysctl >> settings with the default values, no matter what." >=20 > You're forgetting the point I made that the first complete set of shmem > settings wins.=20 Of course I only understood what you said there after I hit the send button= . Now it clicked, thanks for putting it so politely. > 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. Yeah, I wonder if this locking down somehow doesn't work on my machine. I mean I successfully changed all of the other shm value via that file, only that shmmax value would'nt budge. > BTW, I dunno if you read awk at all, but that awk command effectively > says "print lines that contain =3D and do not contain #". Ah, no I wasn't aware of this. > You didn't try > appending comments to the setting lines in your file did you? No, i didn't.=20 I think I will try messing with the rc file directly. Thanks, Maximilian Tyrtania | IT-Entwickler Mty@fischerAppelt.de fischerAppelt Kommunikation GmbH Friedichstr. 149 | D-10117 Berlin | Germany Tel. ++49-30-726146-728 | Fax ++49-30-726146-710 www.fischerAppelt.de --------------------------------------------------------------------------- Sitz der Gesellschaft: Hamburg Standorte: Hamburg, Berlin, D=FCsseldorf, Frankfurt, M=FCnchen, Stuttgart Die Gesellschaft ist Teil des Everpublic Networks Handelsregister: Amtsgericht Hamburg, HRB 49259 Gesch=E4ftsf=FChrer: Andreas Fischer-Appelt, Bernhard Fischer-Appelt +++ fischerAppelt macht Fernsehen: www.fischerappelt-tvmedia.com +++