Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0E1149F9E34 for ; Mon, 29 Oct 2007 07:42:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 42352-04 for ; Mon, 29 Oct 2007 07:41:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cluster-h.mailcontrol.com (cluster-h.mailcontrol.com [85.115.42.190]) by postgresql.org (Postfix) with ESMTP id CE18C9F9E2B for ; Mon, 29 Oct 2007 07:42:06 -0300 (ADT) Received: from cluster-e.mailcontrol.com (rly26e.srv.mailcontrol.com [10.69.1.136]) by rly17h.srv.mailcontrol.com (MailControl) with ESMTP id l9TAg45Y018454 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Mon, 29 Oct 2007 10:42:05 GMT Received: from rly26e.srv.mailcontrol.com (localhost.localdomain [127.0.0.1]) by rly26e.srv.mailcontrol.com (MailControl) with ESMTP id l9TAfxno010760 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 29 Oct 2007 10:42:00 GMT Received: from submission.mailcontrol.com (submission.mailcontrol.com [86.111.216.190]) by rly26e.srv.mailcontrol.com (MailControl) id l9TAf3gb007426 for pgsql-admin@postgresql.org; Mon, 29 Oct 2007 10:41:03 GMT Received: from jupiter.egsgroup.com (jupiter.egsgroup.com [217.199.182.198]) by rly26e-eth0.srv.mailcontrol.com (envelope-sender alexander.stanier@egsgroup.com) (MIMEDefang) with ESMTP id l9TAf0Zf007145; Mon, 29 Oct 2007 10:41:03 +0000 (GMT) Received: by jupiter.egsgroup.com (Postfix, from userid 65) id 5204970E3; Mon, 29 Oct 2007 10:40:32 +0000 (GMT) X-Scanned-By: MailControl A-07-08-10 (www.mailcontrol.com) on 10.69.1.136 X-Scanned-By: AMaViS-ng at egsgroup.com Received: from [10.20.0.98] (unknown [217.150.127.117]) by jupiter.egsgroup.com (Postfix) with ESMTP id 68965AF; Mon, 29 Oct 2007 10:40:31 +0000 (GMT) Message-ID: <4725B8A2.8090805@egsgroup.com> Date: Mon, 29 Oct 2007 10:40:34 +0000 From: Alexander Stanier Organization: EGS Ltd User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Maximilian Tyrtania Cc: Tom Lane , "pgsql-admin@postgresql.org" Subject: Re: shared memory settings on MAC OS X References: In-Reply-To: Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.73 tagged_above=0 required=5 tests=AWL=-0.729, BAYES_50=0.001, HTML_MESSAGE=0.001, MIME_HTML_ONLY=1.457 X-Spam-Level: X-Archive-Number: 200710/284 X-Sequence-Number: 27198 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!
Alex Stanier
EGS Limited

Direct Line: +44 (0) 20 7539 2811
Switchboard: +44 (0) 20 7539 2828
Fax: +44 (0) 20 7539 2829
www.egsgroup.com

Registered Address: Baird House, 15-17 St Cross Street, London EC1N 8UW
Registered Number: 4006942


Maximilian Tyrtania wrote:
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@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 +++





---------------------------(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 http://www.blackspider.com  

  


This message has been scanned for malware by SurfControl plc. www.surfcontrol.com