Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A0F4C9F9FEA for ; Mon, 29 Oct 2007 06:13:54 -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 67490-10 for ; Mon, 29 Oct 2007 06:13:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fischerappelt.de (mail.fischerappelt.com [217.110.127.211]) by postgresql.org (Postfix) with ESMTP id 6CC489F9FE6 for ; Mon, 29 Oct 2007 06:13:48 -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 5505065; Mon, 29 Oct 2007 10:13:47 +0100 User-Agent: Microsoft-Entourage/11.3.6.070618 Date: Mon, 29 Oct 2007 10:13:45 +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: AcgaDAGrQFFMq4X/EdyCKgAX8gNwZg== In-Reply-To: <3721.1193598893@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=1.007 tagged_above=0 required=5 tests=AWL=-0.390, BAYES_50=0.001, MIME_QP_LONG_LINE=1.396 X-Spam-Level: * X-Archive-Number: 200710/283 X-Sequence-Number: 27197 Hi again, 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. The critical part in my /etc/sysctl.conf file looks like this: if [ -f /etc/sysctl.conf ]; then awk '{ if (!index($1, "#") && index($1, "=3D")) print $1 }' < /etc/sysctl.conf | while read do sysctl -w ${REPLY} done fi sysctl -w kern.sysv.shmmax=3D4194304 kern.sysv.shmmin=3D1 kern.sysv.shmmni=3D32 kern.sysv.shmseg=3D8 kern.sysv.shmall=3D1024 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." I know that my understanding is wrong though, because I tried changing the settings on my local machine via the /etc/sysctl.conf file, and it worked. But not on the machine that's supposed to be our pg server. > As a debugging measure, see what happens if you change that last > sysctl line in /etc/rc. Okay, I will try that. 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 +++