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

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

Theodore Petrosky <tedpet5 (AT) yahoo (DOT) com> writes:
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 (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

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 (AT) sss (DOT) pgh.pa.us> wrote:
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

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

Theodore Petrosky <tedpet5 (AT) yahoo (DOT) com> writes:
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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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 (AT) samurai (DOT) com> wrote:
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
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

Neil Conway <neilc (AT) samurai (DOT) com> writes:
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

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 (AT) sss (DOT) pgh.pa.us> wrote:
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
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

Theodore Petrosky <tedpet5 (AT) yahoo (DOT) com> writes:
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/writing...resources.html

ISTM this is already documented.

-Neil


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