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 09:13:45
Message-ID: C34B62D9.2B38E%mty@fischerappelt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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, "=")) print $1 }' <
/etc/sysctl.conf | while read
do
sysctl -w ${REPLY}
done
fi

sysctl -w kern.sysv.shmmax=4194304 kern.sysv.shmmin=1 kern.sysv.shmmni=32
kern.sysv.shmseg=8 kern.sysv.shmall=1024

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(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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alexander Stanier 2007-10-29 10:40:34 Re: shared memory settings on MAC OS X
Previous Message Suresh Gupta VG 2007-10-29 09:05:05 Re: Postgresql takes more time to update