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 (AT) postgresql (DOT) org

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:
--
Jim C. Nasby, Database Consultant decibel (AT) decibel (DOT) 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?"

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Are they still running on the default PostgreSQL port number for their
remote administration tool?

---------------------------------------------------------------------------

Jim C. Nasby wrote:
--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Is that tool on OSX Server? I don't have a copy, though I could probably
find out from a friend.

On Fri, Apr 29, 2005 at 11:57:54PM -0400, Bruce Momjian wrote:
Jim C. Nasby, Database Consultant decibel (AT) decibel (DOT) 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?"

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Jim,

I didn't understand your comment

"It appears that you can shrink shmmax but not expand
it."

I did not comment out the kern.sysv.shmmax line and
it appears that my larger setting is sticking. Or is
it? What is that command to return the currrnt values
from the terminal?

Ted

--- "Jim C. Nasby" <decibel (AT) decibel (DOT) org> wrote:
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

decibel (AT) phonebook (DOT) 1[12:31]~:1%sysctl kern.sysv.shmmax
kern.sysv.shmmax: 1024000000

It wouldn't surprise me at all if there was some other black magic at
work here. What I do know is that I had to comment out the sysctl line
in my /etc/rc to get that value to stick. I didn't make notes during my
testing (booting to single user), but if memory serves I was able to do
this:

sysctl -w kern.sysv.shmmax=1024000000 #works
sysctl -w kern.sysv.shmmax=24000000 #also works
sysctl -w kern.sysv.shmmax=1024000000 #doesn't work

What I do know for a fact is that after putting a sleep in /etc/rc after
the sysctl's I was able to verify that my setting from /etc/sysctl.conf
was being applied, but that it was then being over-ridden by the setting
in /etc/rc. Unfortunately, since I only have one mac and it's my primary
computer and testing this requires a number of reboots I'm not keen on
spending more time experimenting with it, but if someone has ideas on a
more elegant fix I'm all ears.

I provided apple feedback about this, btw. Hopefully they'll fix it at
some point.

On Sat, Apr 30, 2005 at 07:00:57AM -0700, Theodore Petrosky wrote:
--
Jim C. Nasby, Database Consultant decibel (AT) decibel (DOT) 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?"

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Jim,

this is copied from /etc/rc...
\
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


this is copied and pasted from my /etc/sysctl.conf:
kern.sysv.shmmax=33554432
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.sysv.shmall=65536

here is my responce from the terminal

postgres$ sysctl kern.sysv.shmmax
kern.sysv.shmmax: 33554432

postgres$ sysctl kern.sysv.shmall
kern.sysv.shmall: 65536


It looks like my settings in /etc/sysctl.conf are
sticking just fine


Ted

--- "Jim C. Nasby" <decibel (AT) decibel (DOT) org> wrote:



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

I don't doubt that it works for some people. I also know that it doesn't
work on my powerbook as of the last OS update.

On Sat, Apr 30, 2005 at 11:42:36AM -0700, Theodore Petrosky wrote:
--
Jim C. Nasby, Database Consultant decibel (AT) decibel (DOT) 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?"

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings