I am seeing an odd failure of initdb.exe (postgres 8.0.1) on windows that
I have not encountered before. The output from initdb is:

The database cluster will be initialized with locale C.

creating directory D:/E-NetAware-Data/db ... ok
creating directory D:/E-NetAware-Data/db/global ... ok
creating directory D:/E-NetAware-Data/db/pg_xlog ... ok
creating directory D:/E-NetAware-Data/db/pg_xlog/archive_status ... ok
creating directory D:/E-NetAware-Data/db/pg_clog ... ok
creating directory D:/E-NetAware-Data/db/pg_subtrans ... ok
creating directory D:/E-NetAware-Data/db/base ... ok
creating directory D:/E-NetAware-Data/db/base/1 ... ok
creating directory D:/E-NetAware-Data/db/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template database in D:/E-NetAware-Data/db/base/1 ... FATAL:
could not create shared memory segment: No such file or directory
DETAIL: Failed system call was shmget(key=1, size=1163264, 03600).
child process was terminated by signal 1
initdb: failed
initdb: removing data directory "D:/E-NetAware-Data/db"

I have seen the "could not create shared memory segment" error in the past
when running the cygwin based port of postges on windows when I had
forgotten to run cygipc first. I've also seen it on solaris boxes before
bumping up their kernel resources in /etc/system. I have never seen it in
the native port of postgres on windows however.

Any suggestions? Thanks in advance.

Steve McWilliams




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