Thread: Problem with initdb on new machine - NON-HTML post (sorry)
installed cygipc version 1.11-1 and start the ipc-daemon, but I still get the message: IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not implemented I verified the ipc-daemon was running with ps. mminnie@MINNIE2533 ~ $ ps PID PPID PGID WINPID TTY UID STIME COMMAND 3220 1 3220 3220 con 1000 12:44:42 /usr/bin/bash 1968 3220 1968 1404 con 1000 12:44:54 /usr/local/bin/ipc-daemo n 1160 3220 1160 2328 con 1000 12:44:55 /usr/bin/ps mminnie@MINNIE2533 ~ $ initdb -D /usr/share/postgresql/data7 The files belonging to this database system will be owned by user "mminnie". This user must also own the server process. creating directory /usr/share/postgresql/data7... ok creating directory /usr/share/postgresql/data7/base... ok creating directory /usr/share/postgresql/data7/global... ok creating directory /usr/share/postgresql/data7/pg_xlog... ok creating directory /usr/share/postgresql/data7/pg_clog... ok creating template1 database in /usr/share/postgresql/data7/base/1... IpcSemaphor eCreate: semget(key=1, num=17, 03600) failed: Function not implemented initdb failed. Removing /usr/share/postgresql/data7. What am I doing wrong?
Mark, On Fri, Nov 29, 2002 at 01:02:41PM -0800, Mark Minnie wrote: > installed cygipc version 1.11-1 ... > [snip] > What am I doing wrong? For starters, you did not install the latest version of cygipc (i.e., 1.13-2). 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
Thanks. That worked! ----- Original Message ----- From: "Jason Tishler" <jason@tishler.net> To: "Mark Minnie" <postgresql@minniebyte.com> Cc: <pgsql-cygwin@postgresql.org> Sent: Friday, November 29, 2002 7:09 PM Subject: Re: [CYGWIN] Problem with initdb on new machine - NON-HTML post (sorry) > Mark, > > On Fri, Nov 29, 2002 at 01:02:41PM -0800, Mark Minnie wrote: > > installed cygipc version 1.11-1 ... > > [snip] > > What am I doing wrong? > > For starters, you did not install the latest version of cygipc (i.e., > 1.13-2). > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
Mark, On Fri, Nov 29, 2002 at 10:21:31PM -0800, Mark Minnie wrote: > Thanks. That worked! You are very welcome. Was your only change upgrading to cygipc to 1.13-2? Please confirm or deny this. IIRC, Cygwin PostgreSQL could tolerate a cygipc version mismatch between the build and runtime environment in the past. Apparently, this is no longer (or not always) the case. If so, then I need to note this in my README. Thanks, 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
It must have been the change to cygipc 1.13-2 because that is the only thing that I changed. I could have been something else due to my limited knowledge of Cygwin and PostgreSQL. ----- Original Message ----- From: "Jason Tishler" <jason@tishler.net> To: "Mark Minnie" <postgresql@minniebyte.com> Cc: <pgsql-cygwin@postgresql.org> Sent: Sunday, December 01, 2002 6:22 PM Subject: Re: [CYGWIN] Problem with initdb on new machine - NON-HTML post (sorry) > Mark, > > On Fri, Nov 29, 2002 at 10:21:31PM -0800, Mark Minnie wrote: > > Thanks. That worked! > > You are very welcome. > > Was your only change upgrading to cygipc to 1.13-2? Please confirm or > deny this. > > IIRC, Cygwin PostgreSQL could tolerate a cygipc version mismatch between > the build and runtime environment in the past. Apparently, this is no > longer (or not always) the case. If so, then I need to note this in my > README. > > Thanks, > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
I had to update cygipc to get postgresql 7.2.3-2 to work on my WinNT system. Here's the story. I recently upgraded my Cygwin installation picking up postgresql-7.2.3-2 in the process, replacing version 7.2.3-1. When I tried to start the postmaster service again it would fail leaving this message in /var/log/postmaster.log: IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Function not implemented Removing the MultiFile* and cygipc* files in /tmp did not help. However, installing cygipc 1.13-2 fixed the problem and the postmaster service is running fine again. I had been running version 1.09-2 of cygipc. -- Fred Yankowski fred@ontosys.com tel: +1.630.879.1312 OntoSys, Inc PGP keyID: 7B449345 fax: +1.630.879.1370 www.ontosys.com 38W242 Deerpath Rd, Batavia, IL 60510-9461, USA