pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 +++







view thread (9+ messages)  latest in thread

Message-ID: <C34BA4E5.2B3B4%mty@fischerappelt.de>
Permalink:  ../C34BA4E5.2B3B4%25mty@fischerappelt.de/
Also on:    postgresql.org/message-id/C34BA4E5.2B3B4%mty@fischerappelt.de

 · 

reply

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