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