Thread: RC2 will not make check on OSX 10.3
This is the initdb.log for my OS X 10.3.1 system.
the install was made with.
./configure
make
make check.
Ted
Running in noclean mode. Mistakes will not be cleaned
up.
The files belonging to this database system will be
owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale
C.
creating directory
/Users/postgres/software/postgresql-7.4RC2/src/test/regress/./tmp_check/data...
ok
creating directory
/Users/postgres/software/postgresql-7.4RC2/src/test/regress/./tmp_check/data/base...
ok
creating directory
/Users/postgres/software/postgresql-7.4RC2/src/test/regress/./tmp_check/data/global...
ok
creating directory
/Users/postgres/software/postgresql-7.4RC2/src/test/regress/./tmp_check/data/pg_xlog...
ok
creating directory
/Users/postgres/software/postgresql-7.4RC2/src/test/regress/./tmp_check/data/pg_clog...
ok
selecting default max_connections... 10
selecting default shared_buffers... 50
creating configuration files... ok
creating template1 database in
/Users/postgres/software/postgresql-7.4RC2/src/test/regress/./tmp_check/data/base/1...
FATAL: could not create shared memory segment: Cannot
allocate memory
DETAIL: Failed system call was shmget(key=1,
size=1081344, 03600).
HINT: This error usually means that PostgreSQL's
request for a shared memory segment exceeded available
memory or swap space. To reduce the request size
(currently 1081344 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 50) and/or its
max_connections parameter (currently 10).
The PostgreSQL documentation contains more
information about shared memory configuration.
initdb: failed
initdb: data directory
"/Users/postgres/software/postgresql-7.4RC2/src/test/regress/./tmp_check/data"
not removed at user's request
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
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
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.
John
Theodore Petrosky wrote:
<blockquote cite="mid20031116014039.97987.qmail@web41005.mail.yahoo.com"
type="cite">
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"><neilc@samurai.com> wrote:
Theodore Petrosky <a class="moz-txt-link-rfc2396E"
href="mailto:tedpet5@yahoo.com"><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
<a class="moz-txt-link-freetext"
href="http://antispam.yahoo.com/whatsnewfree">http://antispam.yahoo.com/whatsnewfree
---------------------------(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