RC2 will not make check on OSX 10.3

Theodore Petrosky <tedpet5@yahoo.com> writes:

FATAL: could not create shared memory segment: Cannot
allocate memory
DETAIL: Failed system call was shmget(key=1,
size=1081344, 03600).

You need to increase SHMMAX.

regards, tom lane

After about two hours of hunting pecking and anything
else I found where you control this in OSX 10.3

you must edit the /etc/rc file.

/System/Library/StartupItems/SystemTuning/SystemTuning
does nothing....

now.. 7.4 RC2 make check only fails on the geometry
test....

type_sanity ... ok
opr_sanity ... ok
test geometry ... FAILED
test horology ... ok
test insert ... ok
test create_function_1 ... ok
test create_type ... ok

I hope if someone searches on OSX (OS X) SystemTuning
they find this....

edit rc... on about the second page you will find the
settings.

This is what I have and it is working... I don't
know if it is optimal..

Ted

# System tuning
sysctl -w kern.maxvnodes=$(echo $(sysctl -n
hw.physmem) '33554432 / 512 * 1024 +p'|dc)
sysctl -w kern.sysv.shmmax=167772160
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=65536

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

Theodore Petrosky <tedpet5@yahoo.com> writes:

FATAL: could not create shared memory segment:

Cannot

allocate memory
DETAIL: Failed system call was shmget(key=1,
size=1081344, 03600).

You need to increase SHMMAX.

regards, tom lane

---------------------------(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

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

Theodore Petrosky <tedpet5@yahoo.com> writes:

After about two hours of hunting pecking and anything
else I found where you control this in OSX 10.3

you must edit the /etc/rc file.

/System/Library/StartupItems/SystemTuning/SystemTuning
does nothing....

Should we update the documentation's advice? At present, it suggests:

MacOS X

Edit the file /System/Library/StartupItems/SystemTuning/SystemTuning and change the following values:

sysctl -w kern.sysv.shmmax
sysctl -w kern.sysv.shmmin
sysctl -w kern.sysv.shmmni
sysctl -w kern.sysv.shmseg
sysctl -w kern.sysv.shmall

(Without a Mac OSX box, I have no idea which is correct.)

-Neil

Neil,

I posted to the apple site asking if anyone could
recommend the 'correct' place to edit these settings.
I don't think a change like this would survive a
system update.....

But it was the only way I got the settings to 'take'.

It deserves to be mentioned in the docs that this is
necessary at least as far as 10.3.1 (osx).

Ted

--- Neil Conway <neilc@samurai.com> wrote:

Theodore Petrosky <tedpet5@yahoo.com> writes:

After about two hours of hunting pecking and

anything

else I found where you control this in OSX 10.3

you must edit the /etc/rc file.

/System/Library/StartupItems/SystemTuning/SystemTuning

does nothing....

Should we update the documentation's advice? At
present, it suggests:

MacOS X

Edit the file

/System/Library/StartupItems/SystemTuning/SystemTuning

and change the following values:

sysctl -w kern.sysv.shmmax
sysctl -w kern.sysv.shmmin
sysctl -w kern.sysv.shmmni
sysctl -w kern.sysv.shmseg
sysctl -w kern.sysv.shmall

(Without a Mac OSX box, I have no idea which is
correct.)

-Neil

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

Neil Conway <neilc@samurai.com> writes:

Should we update the documentation's advice?

Looks that way. On my 10.3 beta installation, the "SystemTuning" file
is present but it's just a stub ("exit 0"). The shmem sysctl calls have
been moved into /etc/rc. I presume this is deliberate, so we should
adjust our docs to match. I'll do so ...

regards, tom lane

BTW,

I find it difficult to understand exactally what
reasonable values are.

Is it possible in the docs to explain a little what
these values should be. Or how to calculate them. I
felt totally in the dark. If I hadn't fallen across an
email on one of the sites that suggested values, I
think I wouldn't have succeeded. Luckily they worked.

There should be some way to recommend values.....

Ted

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

Neil Conway <neilc@samurai.com> writes:

Should we update the documentation's advice?

Looks that way. On my 10.3 beta installation, the
"SystemTuning" file
is present but it's just a stub ("exit 0"). The
shmem sysctl calls have
been moved into /etc/rc. I presume this is
deliberate, so we should
adjust our docs to match. I'll do so ...

regards, tom lane

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

http://archives.postgresql.org

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

Theodore Petrosky <tedpet5@yahoo.com> writes:

I find it difficult to understand exactally what
reasonable values are.

This page in the documentation includes a table that specifies
"reasonable values" for all of the SysV IPC settings:

http://candle.pha.pa.us/main/writings/pgsql/sgml/kernel-resources.html

ISTM this is already documented.

-Neil

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
I am certainly not an expert in OSX, but many Unix variants have to
have the changes made in the conf directories; then the kernel has to
be rebuilt AND the environment rebuilt. It is not a one step process on
all Unix variants. I don't know for sure, but rebuilding the
environment after making the changes to the files in the conf
directories may rebuild the rc files.<br>
<br>
John<br>
<br>
Theodore Petrosky wrote:<br>
<blockquote cite="mid20031116014039.97987.qmail@web41005.mail.yahoo.com"
type="cite">
<pre wrap="">Neil,

I posted to the apple site asking if anyone could
recommend the 'correct' place to edit these settings.
I don't think a change like this would survive a
system update.....

But it was the only way I got the settings to 'take'.

It deserves to be mentioned in the docs that this is
necessary at least as far as 10.3.1 (osx).

Ted

--- Neil Conway <a
 class="moz-txt-link-rfc2396E" href="mailto:neilc@samurai.com">&lt;neilc@samurai.com&gt;</a> wrote:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Theodore Petrosky <a class="moz-txt-link-rfc2396E"
 href="mailto:tedpet5@yahoo.com">&lt;tedpet5@yahoo.com&gt;</a> writes:
    </pre>
    <blockquote type="cite">
      <pre wrap="">After about two hours of hunting pecking and
      </pre>
    </blockquote>
    <pre wrap="">anything
    </pre>
    <blockquote type="cite">
      <pre wrap="">else I found where you control this in OSX 10.3

you must edit the /etc/rc file.

</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->/System/Library/StartupItems/SystemTuning/SystemTuning
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""> does nothing....
</pre>
</blockquote>
<pre wrap="">Should we update the documentation's advice? At
present, it suggests:

MacOS X

Edit the file

</pre>
</blockquote>
<pre wrap=""><!---->/System/Library/StartupItems/SystemTuning/SystemTuning
</pre>
<blockquote type="cite">
<pre wrap="">and change the following values:

sysctl -w kern.sysv.shmmax
sysctl -w kern.sysv.shmmin
sysctl -w kern.sysv.shmmni
sysctl -w kern.sysv.shmseg
sysctl -w kern.sysv.shmall

(Without a Mac OSX box, I have no idea which is
correct.)

-Neil

</pre>
</blockquote>
<pre wrap=""><!---->
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
<a class="moz-txt-link-freetext"
href="http://antispam.yahoo.com/whatsnewfree&quot;&gt;http://antispam.yahoo.com/whatsnewfree&lt;/a&gt;

---------------------------(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
</pre>
</blockquote>
</body>
</html>