That's interesting. On my powerbook, I had to comment out the sysctl -w
kern.sysv.shmmax line in /etc/rc. It appears that you can shrink shmmax
but not expand it. This meant that it would properly set it based on
/etc/syscttl.conf, but that (large) setting would then be over-written
by the subsiquent sysctl -w.
On Fri, Apr 29, 2005 at 09:39:55AM -0700, Theodore Petrosky wrote:
> I just updated to 10.3.9 and of course the /etc/rc was
> dinged. I opened the /etc/rc and found a change..
>
> # System tuning
> sysctl -w kern.maxvnodes=$(echo $(sysctl -n
> hw.physmem) '33554432 / 512 * 1024 +p'|dc)
> if [ -f /etc/sysctl-macosxserver.conf ]; then
> awk '{ if (!index($1, "#") && index($1, "="))
> print $1 }' < /etc/sysctl-macosxserver.conf | while
> read
> do
> sysctl -w ${REPLY}
> done
> fi
>
> 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
> sysctl -w kern.sysv.shmmin=1
> sysctl -w kern.sysv.shmmni=32
> sysctl -w kern.sysv.shmseg=8
> sysctl -w kern.sysv.shmall=1024
>
> It appears that apple is checking for etc/sysctl.conf
> before setting the sysctl values. so I created a
> etc/sysctl.conf with this inside:
>
> kern.sysv.shmmax=33554432
> kern.sysv.shmmin=1
> kern.sysv.shmmni=32
> kern.sysv.shmseg=8
> kern.sysv.shmall=65536
>
> I did not alter /etc/rc. postgresql starts up just
> fine. I hope this implys that the issue is resolved..
>
> Ted
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"