Thread: PostgreSQL 7.3 under Windows/cygwin: initdb fails with error IpcSemaphoreCreate: semget ... failed: Function not implemented

Hi,

I have a serious problem installing PostgreSQL 7.3 on Windows.
I have an up-to-date cygwin installation under Windows2000 Server sp3,
installed the cygipc 1.11-1 package as instructed,
but I fail to initialize the database.

Querying www.boost.com and groups.boost.com was not much help, much
problems related to the error message
"IpcSemaphoreCreate: semget" "Function not implemented" do not relate to
Windows/cygwin, and I found nothing that helps to get ahead.

Here the steps taken:

hrs@HRSW2KSRV2 ~
$ cygcheck -V
cygcheck version 1.29
System Checker for Cygwin
Copyright 1998, 1999, 2000, 2001, 2002 Red Hat, Inc.
Compiled on Nov 27 2002

hrs@HRSW2KSRV2 ~
$ ipc-daemon &
[1] 1536

hrs@HRSW2KSRV2 ~
$ ls -la /var/pgdata
total 4
drwx------+   2 Administ 65535        4096 Dec 26 22:38 .
drwxrwxrwx+   8 Administ None            0 Dec 26 13:28 ..

hrs@HRSW2KSRV2 ~
$ ps -ef
     UID     PID    PPID TTY     STIME COMMAND
     hrs    1616       1 con  00:26:53 /usr/bin/bash
     hrs    1536    1616 con  00:29:05 /usr/local/bin/ipc-daemon
     hrs    1264    1616 con  00:31:15 /usr/bin/ps

hrs@HRSW2KSRV2 ~
$ cygcheck -c postgresql
Cygwin Package Information
Package             Version
postgresql          7.3-1

Use -h to see help about each section

hrs@HRSW2KSRV2 ~
$ initdb -D /var/pgdata
The files belonging to this database system will be owned by user "hrs".
This user must also own the server process.

The database cluster will be initialized with locale C.

Fixing permissions on existing directory /var/pgdata... ok
creating directory /var/pgdata/base... ok
creating directory /var/pgdata/global... ok
creating directory /var/pgdata/pg_xlog... ok
creating directory /var/pgdata/pg_clog... ok
creating template1 database in /var/pgdata/base/1... IpcSemaphoreCreate:
semget(key=1, num=17, 03600) failed: Function n
ot implemented

initdb failed.

hrs@HRSW2KSRV2 ~
$




Re: PostgreSQL 7.3 under Windows/cygwin: initdb fails with

From
Jason Tishler
Date:
Peter,

On Fri, Dec 27, 2002 at 12:38:08AM +0100, Peter Frey wrote:
> I have a serious problem installing PostgreSQL 7.3 on Windows.
> I have an up-to-date cygwin installation under Windows2000 Server sp3,
> installed the cygipc 1.11-1 package as instructed,
                       ^^^^^^

Sigh...

Please read the README:

    http://www.tishler.net/jason/software/postgresql/postgresql-7.3.README

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6