Re: shared memory settings on MAC OS X

From: Maximilian Tyrtania <mty(at)fischerappelt(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: shared memory settings on MAC OS X
Date: 2007-10-29 13:55:33
Message-ID: C34BA4E5.2B3B4%mty@fischerappelt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Von: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)fischerAppelt(dot)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 +++

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kuriakose, Cinu Cheriyamoozhiyil 2007-10-29 14:15:30 grep command
Previous Message Tom Lane 2007-10-29 13:40:10 Re: shared memory settings on MAC OS X