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

Are you by any chance running this through terminal services? This looks
just like the error message you get if you try that.


//Magnus

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