Thread: 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"

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

>I am seeing an odd failure of initdb.exe (postgres 8.0.1) on=20
>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:=20
>could not create shared memory segment: No such file or directory
>DETAIL:  Failed system call was shmget(key=3D1, size=3D1163264, 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