Thread: help installing postgres with cygwin - initdb: IpcSemaphoreCreate fails

help installing postgres with cygwin - initdb: IpcSemaphoreCreate fails

From
"Claudia Beleites"
Date:
Hello,

I know there are several postings that seem to have a similar problem, but I
coudn't solve it with these texts. :-(

I installed cygwin and try to use the postgresql-package that comes with it.
The cygipc is version 2.01-2, I replaced the cygwin1.dll by a new one
(1.5.2).

Following the README [v1.36 2003/08/05] using the NT procedure, I get to the
point where I should run initdb as "posgres". Then the "famous" error
occurs:
IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not
implemented

A detailed listing of what I did as user postges and a cygcheck follows. Can
you give me some hints what the problem could be?

Thanks,

Claudia


postgres@CAL7115 ~
$ ipctest s
Test v0.03
semaphore 0 created

postgres@CAL7115 ~
$ ls /usr/share/postgresql
contrib                java                pg_ident.conf.sample
postgres.description
conversion_create.sql  pg_hba.conf.sample  postgres.bki
postgresql.conf.sample

postgres@CAL7115 ~
$ mkdir /usr/share/postgresql/data

postgres@CAL7115 ~
$ ls -l  /usr/share/postgresql
total 317
drwxrwxrwx+   2 Administ mkgroup_        0 Aug 13 13:07 contrib
-rwxrwxrwx    1 Administ mkgroup_    38176 Aug  1 22:02
conversion_create.sql
drwxr-xr-x+   2 postgres Kein            0 Aug 13 17:06 data
drwxrwxrwx+   2 Administ mkgroup_        0 Aug 13 13:07 java
-rwxrwxrwx    1 Administ mkgroup_     2329 Aug  1 22:02 pg_hba.conf.sample
-rwxrwxrwx    1 Administ mkgroup_     1441 Aug  1 22:02 pg_ident.conf.sample
-rwxrwxrwx    1 Administ mkgroup_   225499 Aug  1 22:02 postgres.bki
-rwxrwxrwx    1 Administ mkgroup_    48711 Aug  1 22:02 postgres.description
-rwxrwxrwx    1 Administ mkgroup_     5043 Aug  1 22:02
postgresql.conf.sample

postgres@CAL7115 ~
$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

Fixing permissions on existing directory /usr/share/postgresql/data... ok
creating directory /usr/share/postgresql/data/base... ok
creating directory /usr/share/postgresql/data/global... ok
creating directory /usr/share/postgresql/data/pg_xlog... ok
creating directory /usr/share/postgresql/data/pg_clog... ok
creating template1 database in /usr/share/postgresql/data/base/1...
IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not
implemented

initdb failed.

postgres@CAL7115 ~
$ ls -l /tmp
total 4050
-rw-rw-rw-    1 SYSTEM   Administ  3916720 Aug 13 17:03 MultiFileMsg2
-rw-rw-rw-    1 SYSTEM   Administ    23568 Aug 13 17:03 MultiFileSem2
-rw-rw-rw-    1 SYSTEM   Administ   204304 Aug 13 17:03 MultiFileShm2
-rw-r--r--    1 postgres Kein         1000 Aug 13 16:19 cygipc2_0

postgres@CAL7115 ~
$ ls -ld /tmp
drwxrwxrwx+   2 Administ mkgroup_     4096 Aug 13 16:34 /tmp

postgres@CAL7115 ~
$ cygcheck -s
Cygwin Win95/NT Configuration Diagnostics
Current System Time: Wed Aug 13 16:38:05 2003

Windows 2000 Professional Ver 5.0 Build 2195 Service Pack 1

Path:    C:\cygwin\usr\local\bin
    C:\cygwin\bin
    C:\cygwin\bin
    c:\WINNT\system32
    c:\WINNT
    c:\WINNT\System32\Wbem
    c:\WIN32APP\TOOLKIT
    c:\Programme\Gemeinsame Dateien\MDL Shared\ISIS

C:\cygwin\bin\id.exe output (nontsec)
UID: 1005(postgres)  GID: 513(Kein)
513(Kein)

C:\cygwin\bin\id.exe output (ntsec)
UID: 1005(postgres)  GID: 513(Kein)
513(Kein)            545(Benutzer)

SysDir: C:\WINNT\System32
WinDir: C:\WINNT

HOME = `C:\cygwin\home\postgres'
MAKE_MODE = `unix'
PWD = `/home/postgres'
USER = `postgres'

Use `-r' to scan registry

a:  fd           N/A    N/A
c:  hd  NTFS   19539Mb  21% CP CS UN PA FC     DRIVE_C
d:  hd  NTFS   19539Mb   2% CP CS UN PA FC     Datenträger
e:  cd           N/A    N/A

C:\cygwin      /          system  textmode
C:\cygwin/bin  /usr/bin   system  textmode
C:\cygwin/lib  /usr/lib   system  textmode
.              /cygdrive  system  textmode,cygdrive

Found: C:\cygwin\bin\awk.exe
Found: C:\cygwin\bin\bash.exe
Found: C:\cygwin\bin\cat.exe
Found: C:\cygwin\bin\cp.exe
Found: C:\cygwin\bin\cpp.exe
Found: C:\cygwin\bin\find.exe
Found: C:\cygwin\bin\gcc.exe
Not Found: gdb
Found: C:\cygwin\bin\grep.exe
Found: C:\cygwin\bin\ld.exe
Found: C:\cygwin\bin\ls.exe
Found: C:\cygwin\bin\make.exe
Found: C:\cygwin\bin\mv.exe
Found: C:\cygwin\bin\rm.exe
Found: C:\cygwin\bin\sed.exe
Found: C:\cygwin\bin\sh.exe
Found: C:\cygwin\bin\tar.exe

   58k 2002/05/07 C:\cygwin\bin\cygbz2-1.dll
   28k 2003/08/11 C:\cygwin\bin\cygcygipc-2.dll
   45k 2001/04/25 C:\cygwin\bin\cygform5.dll
   35k 2002/01/09 C:\cygwin\bin\cygform6.dll
   76k 2003/03/09 C:\cygwin\bin\cygform7.dll
   28k 2003/07/20 C:\cygwin\bin\cyggdbm-3.dll
   30k 2003/08/11 C:\cygwin\bin\cyggdbm-4.dll
   19k 2003/03/22 C:\cygwin\bin\cyggdbm.dll
   15k 2003/07/20 C:\cygwin\bin\cyggdbm_compat-3.dll
   15k 2003/08/11 C:\cygwin\bin\cyggdbm_compat-4.dll
   17k 2001/06/28 C:\cygwin\bin\cyghistory4.dll
   20k 2002/10/10 C:\cygwin\bin\cyghistory5.dll
  945k 2003/06/18 C:\cygwin\bin\cygiconv-2.dll
   22k 2001/12/13 C:\cygwin\bin\cygintl-1.dll
   28k 2002/09/20 C:\cygwin\bin\cygintl-2.dll
   47k 2003/03/09 C:\cygwin\bin\cygjbig1.dll
   26k 2001/04/25 C:\cygwin\bin\cygmenu5.dll
   20k 2002/01/09 C:\cygwin\bin\cygmenu6.dll
   48k 2003/03/09 C:\cygwin\bin\cygmenu7.dll
  156k 2001/04/25 C:\cygwin\bin\cygncurses++5.dll
  175k 2002/01/09 C:\cygwin\bin\cygncurses++6.dll
  226k 2001/04/25 C:\cygwin\bin\cygncurses5.dll
  202k 2002/01/09 C:\cygwin\bin\cygncurses6.dll
  284k 2003/03/09 C:\cygwin\bin\cygncurses7.dll
   15k 2001/04/25 C:\cygwin\bin\cygpanel5.dll
   12k 2002/01/09 C:\cygwin\bin\cygpanel6.dll
   31k 2003/03/09 C:\cygwin\bin\cygpanel7.dll
   63k 2003/04/11 C:\cygwin\bin\cygpcre.dll
   61k 2003/04/11 C:\cygwin\bin\cygpcreposix.dll
   22k 2002/06/09 C:\cygwin\bin\cygpopt-0.dll
  108k 2001/06/28 C:\cygwin\bin\cygreadline4.dll
  127k 2002/10/10 C:\cygwin\bin\cygreadline5.dll
   50k 2002/03/12 C:\cygwin\bin\cygz.dll
  948k 2003/08/13 C:\cygwin\bin\cygwin1.dll
    Cygwin DLL version info:
        DLL version: 1.5.2
        DLL epoch: 19
        DLL bad signal mask: 19005
        DLL old termios: 5
        DLL malloc env: 28
        API major: 0
        API minor: 90
        Shared data: 3
        DLL identifier: cygwin1
        Mount registry: 2
        Cygnus registry name: Cygnus Solutions
        Cygwin registry name: Cygwin
        Program options name: Program Options
        Cygwin mount registry name: mounts v2
        Cygdrive flags: cygdrive flags
        Cygdrive prefix: cygdrive prefix
        Cygdrive default prefix:
        Build date: Fri Aug 8 15:46:03 EDT 2003
        Snapshot date: 20030808-15:41:15
        Shared id: cygwin1S3


Cygwin Package Information
Package              Version
_update-info-dir     00197-1
ash                  20020731-1
base-files           1.3-1
base-passwd          1.1-1
bash                 2.05b-9
binutils             20030307-1
bzip2                1.0.2-2
cygipc               2.01-2
cygrunsrv            0.96-1
cygutils             1.1.4-2
cygwin               1.3.22-1
cygwin-doc           1.3-4
diffutils            2.8.1-1
fileutils            4.1-1
findutils            4.1.7-4
gawk                 3.1.3-1
gcc                  3.2-3
gcc-mingw            20020817-5
gdbm                 1.8.3-3
grep                 2.5-1
groff                1.18.1-2
gzip                 1.3.3-4
jbigkit              1.4-1
less                 378-1
libbz2_1             1.0.2-2
libgdbm              1.8.0-5
libgdbm-devel        1.8.3-3
libgdbm3             1.8.3-3
libgdbm4             1.8.3-7
libiconv2            1.8-3
libintl1             0.10.40-1
libintl2             0.11.5-1
libncurses5          5.2-1
libncurses6          5.2-8
libncurses7          5.3-1
libpcre              4.1-1
libpopt0             1.6.4-4
libreadline4         4.1-2
libreadline5         4.3-2
login                1.9-5
make                 3.80-1
man                  1.5j-2
mingw-runtime        3.0-1
mktemp               1.4-1
ncurses              5.3-1
newlib-man           20020801
postgresql           7.3.4-1
readline             4.3-2
sed                  4.0.7-1
sh-utils             2.0.15-3
tar                  1.13.25-1
termcap              20021106-2
terminfo             5.3_20030726-1
texinfo              4.2-4
textutils            2.0.21-1
w32api               2.3-1
which                1.5-1
zlib                 1.1.4-1

Use -h to see help about each section



Re: help installing postgres with cygwin - initdb: IpcSemaphoreCreate fails

From
Jason Tishler
Date:
Claudia,

On Wed, Aug 13, 2003 at 05:23:50PM +0200, Claudia Beleites wrote:
> Can you give me some hints what the problem could be?

See the following:

    http://archives.postgresql.org/pgsql-cygwin/2003-08/msg00041.php

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