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