odd initdb.exe failure on windows

Started by Steve McWilliamsabout 21 years ago2 messagesbugs
Jump to latest
#1Steve McWilliams
smcwilliams@EmprisaNetworks.com

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

#2Magnus Hagander
magnus@hagander.net
In reply to: Steve McWilliams (#1)
Re: odd initdb.exe failure on windows

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"

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

//Magnus