looks like apple fixed /etc/rc

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?"

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

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

Jim C. Nasby wrote:

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?"

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

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.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

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:

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

--
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?"

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@decibel.org> wrote:

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?"

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

decibel@phonebook.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,

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@decibel.org> wrote:

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?"

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

--
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?"

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@decibel.org> wrote:

decibel@phonebook.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,

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@decibel.org> wrote:

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

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,

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@decibel.org> wrote:

decibel@phonebook.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,

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@decibel.org> wrote:

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

--
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?"