Re: initdb error on windows - urgent, please

Jarek Lubczyn'ski wrote:
> Hi, everybody,
>
> Please help me with an urgent problem.
>
> I have PostgreSQL version: 7.3.1Alfa1 for Windows (the only Win version available)
>
> I am training installation of ProgreSQL on various PC's WinNT, 2K, XP and 2003
> installed. In some cases I've got such a problem (till now on W2K and W2003)
>
> When I try to initialize dbspace using initdb, for example:
>     .....
>     initdb -D /cygdrive/d/database/postgres --username=myuser -W -E LATIN2
>     .....
>
>    (of course specified path exists and is owned by "myuser")
>
> I will get such information:
>
>     ----
>     The files belonging to this database system will be owned by user "myuser".
>     This user must also own the server process.
>
>     The database cluster will be initialized with locale C.
>
>     Fixing permissions on existing directory /cygdrive/d/database/postgres... ok
>     creating directory /cygdrive/d/database/postgres/base... ok
>     creating directory /cygdrive/d/database/postgres/global... ok
>     creating directory /cygdrive/d/database/postgres/pg_xlog... ok
>     creating directory /cygdrive/d/database/postgres/pg_clog... ok
>     creating template1 database in /cygdrive/d/database/postgres/base/1...
>     IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not
> implemented
>
>     initdb failed.
>     ----
>
> User "myuser" belongs to the administator group of course.
> Any set of initdb options causes the same result (even initdb with no parameters)
>
>
> What is happening? How can I avoid such a problem? Why this seems to occur only
> on:
>   some Win2k installations (two of tested five or six),
>   Win2003(first attempt passed through, second one on the other machine failed)
>
> and never (so far) on
>   WinNT (I've tried one) nor
>   WinXP (four or five cases).
>
> All Windows (except of WinNT) were Polish edition
>
> I have thought it's a matter of service pack installed, but today I installed PostgreSQL
> on one machine with W2003 SE PL and everything went OK, but on other machine
> with the same W2003 initdb failed.
>
> I need an urgent help.
> Thanks in advance.
>

Hi,
You need the IPC support for cygwin. Find it and download the cygipc
package for cygwin. For set up and running PostgreSQL for cygwin please
  read postgresql-...README from ...cygwin\usr\doc\Cygwin
Regards,
    Kerv