From: Maximilian Tyrtania <mty@fischerappelt.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: shared memory settings on MAC OS X
Date: Mon, 29 Oct 2007 14:55:33 +0100
Message-ID: <C34BA4E5.2B3B4%mty@fischerappelt.de> (raw)
In-Reply-To: <4731.1193665210@sss.pgh.pa.us>
> Von: Tom Lane <tgl@sss.pgh.pa.us>
> Datum: Mon, 29 Oct 2007 09:40:10 -0400
>> 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.
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.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.
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 = 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.
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üsseldorf, Frankfurt, München, Stuttgart
Die Gesellschaft ist Teil des Everpublic Networks
Handelsregister: Amtsgericht Hamburg, HRB 49259
Geschäftsführer: Andreas Fischer-Appelt, Bernhard Fischer-Appelt
+++ fischerAppelt macht Fernsehen: www.fischerappelt-tvmedia.com +++
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mty@fischerappelt.de, tgl@sss.pgh.pa.us
Subject: Re: shared memory settings on MAC OS X
In-Reply-To: <C34BA4E5.2B3B4%mty@fischerappelt.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox