pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander Stanier <alexander.stanier@egsgroup.com>
To: Maximilian Tyrtania <mty@fischerappelt.de>
Cc: 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 10:40:34 +0000
Message-ID: <4725B8A2.8090805@egsgroup.com> (raw)
In-Reply-To: <C34B62D9.2B38E%mty@fischerappelt.de>
References: <C34B62D9.2B38E%mty@fischerappelt.de>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
We edit the /etc/rc directly; comment out the line with the default
settings and add a new one just underneath it. The only time this can
cause a problem is that softwareupdate has been known to overwrite our
settings from time to time, but you just have to check after patching
and put it back in if goes. Probably not the right way to do it, but it
has always worked for us!<br>
<pre class="moz-signature" cols="72">Alex Stanier
EGS Limited

Direct Line: +44 (0) 20 7539 2811
Switchboard: +44 (0) 20 7539 2828
Fax: +44 (0) 20 7539 2829
<a class="moz-txt-link-abbreviated" href="http://www.egsgroup.com">www.egsgroup.com</a;

Registered Address: Baird House, 15-17 St Cross Street, London EC1N 8UW
Registered Number: 4006942</pre>
<br>
<br>
Maximilian Tyrtania wrote:
<blockquote cite="mid:C34B62D9.2B38E%25mty@fischerappelt.de" type="cite">
  <pre wrap="">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, "#") &amp;&amp; index($1, "=")) print $1 }' &lt;
/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.

  </pre>
  <blockquote type="cite">
    <pre wrap="">As a debugging measure, see what happens if you change that last
sysctl line in /etc/rc.
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Okay, I will try that.

Thanks,

  Maximilian Tyrtania | IT-Entwickler
  <a class="moz-txt-link-abbreviated" href="mailto:Mty@fischerAppelt.de">Mty@fischerAppelt.de</a>
  fischerAppelt Kommunikation GmbH
  Friedichstr. 149 | D-10117 Berlin | Germany
  Tel. ++49-30-726146-728 | Fax ++49-30-726146-710
  <a class="moz-txt-link-abbreviated" href="http://www.fischerAppelt.de">www.fischerAppelt.de</a;
---------------------------------------------------------------------------
Sitz der Gesellschaft: Hamburg
Standorte: Hamburg, Berlin, D&uuml;sseldorf, Frankfurt, M&uuml;nchen, Stuttgart
Die Gesellschaft ist Teil des Everpublic Networks
Handelsregister: Amtsgericht Hamburg, HRB 49259
Gesch&auml;ftsf&uuml;hrer: Andreas Fischer-Appelt, Bernhard Fischer-Appelt

+++ fischerAppelt macht Fernsehen: <a class="moz-txt-link-abbreviated" href="http://www.fischerappelt-tvmedia.com">www.fischerappelt-tvmedia.com</a; +++





---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match


This email has been scanned for viruses by Blackspider's Mail Control System. 
For more information please visit <a class="moz-txt-link-freetext" href="http://www.blackspider.com">http://www.blackspider.com</a;  

  </pre>
</blockquote>
<br><br>
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">This message has been scanned for malware by SurfControl plc.  </FONT><A href="http://www.surfcontrol.com/"><FONT style="BACKGROUND-COLOR: #ffffff" color=#000000>www.surfcontrol.com</FONT></A></P>
</body>
</html>



view thread (9+ messages)  latest in thread

Message-ID: <4725B8A2.8090805@egsgroup.com>
Permalink:  ../4725B8A2.8090805@egsgroup.com/
Also on:    postgresql.org/message-id/4725B8A2.8090805@egsgroup.com

 · 

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: alexander.stanier@egsgroup.com, mty@fischerappelt.de, tgl@sss.pgh.pa.us
  Subject: Re: shared memory settings on MAC OS X
  In-Reply-To: <4725B8A2.8090805@egsgroup.com>

* 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