initdb error on windows - urgent, please

From: Jarek Lubczyński <eljot(at)elkomtech(dot)com(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: initdb error on windows - urgent, please
Date: 2003-10-01 15:02:44
Message-ID: 3F7B08B4.15865.1E8DFD5@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
greetings
Jaroslaw Lubczynski

---
There are 10 kinds of people:
Those who understand binary and those who don't.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message enio 2003-10-01 17:24:07
Previous Message Scott 2003-10-01 14:36:15 leading choices