Re: Problem with initdb failing - Mailing list pgsql-cygwin

Jason,

Thanks for giving me some direction.  The error was indeed:
IpcSemaphoreCreate: semget(...) failed: Function not implemented

I have run cygcheck as recommended, see log below after I reinstalled cygipc
and postgresql with cygwin's setup... Now I get a problem when starting
postmaster ...


paul_sand@mverify3 ~
$ cygcheck -c cygwin cygipc postgresql
Cygwin Package Information
Package              Version        Status
cygipc               2.01-2         OK
cygwin               1.5.5-1        Incomplete
postgresql           7.3.4-2        OK

paul_sand@mverify3 ~
$ ipc-daemon2 &
[1] 2704

paul_sand@mverify3 ~
$ initdb -D /usr/AMATE/data6
The files belonging to this database system will be owned by user
"paul_sand".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/AMATE/data6... ok
creating directory /usr/AMATE/data6/base... ok
creating directory /usr/AMATE/data6/global... ok
creating directory /usr/AMATE/data6/pg_xlog... ok
creating directory /usr/AMATE/data6/pg_clog... ok
creating template1 database in /usr/AMATE/data6/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

    /usr/bin/postmaster -D /usr/AMATE/data6
or
    /usr/bin/pg_ctl -D /usr/AMATE/data6 -l logfile start

[1]+  Done                    ipc-daemon2

paul_sand@mverify3 ~
$ postmaster -D /usr/AMATE/data6 &

paul_sand@mverify3 ~
$ cygcheck -c cygwin cygipc postgresql
Cygwin Package Information
Package              Version        Status
cygipc               2.01-2         OK
cygwin               1.5.5-1        Incomplete
postgresql           7.3.4-2        OK

paul_sand@mverify3 ~
$ ipc-daemon2 &
[1] 2704

paul_sand@mverify3 ~
$ initdb -D /usr/AMATE/data6
The files belonging to this database system will be owned by user
"paul_sand".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/AMATE/data6... ok
creating directory /usr/AMATE/data6/base... ok
creating directory /usr/AMATE/data6/global... ok
creating directory /usr/AMATE/data6/pg_xlog... ok
creating directory /usr/AMATE/data6/pg_clog... ok
creating template1 database in /usr/AMATE/data6/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

    /usr/bin/postmaster -D /usr/AMATE/data6
or
    /usr/bin/pg_ctl -D /usr/AMATE/data6 -l logfile start

[1]+  Done                    ipc-daemon2

paul_sand@mverify3 ~
$ postmaster -D /usr/AMATE/data6 &
[1] 1836

paul_sand@mverify3 ~
$ LOG:  database system was shut down at 2003-10-31 09:34:21 CST
LOG:  checkpoint record is at 0/83B238
LOG:  redo record is at 0/83B238; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  database system is ready
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 1668) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 2980) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 3208) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 2108) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 696) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 856) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 536) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 2844) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 1408) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 1680) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Resource temporarily unavailable
LOG:  statistics collector process (pid 2860) exited with exit code 1



Regards,

Paul

-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org] On Behalf Of Jason Tishler
Sent: Friday, October 31, 2003 7:49 AM
To: Paul R. Sand
Cc: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] Problem with initdb failing

Paul,

On Thu, Oct 30, 2003 at 03:28:53PM -0600, Paul R. Sand wrote:
> I have the following problem:
>
> I get the error : IpcSemaphoreCreate: semget ? when I run initdb

Is the above the precise error message?  Or, are you getting something
like the following:

    IpcSemaphoreCreate: semget(...) failed: Function not implemented

> I do have cygipc installed and have ipc-daemon running (verified via
> ps)

You might have a version mismatch.  What does the following indicate?

    $ cygcheck -c cygipc cygwin postgresql

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 6: Have you searched our list archives?

               http://archives.postgresql.org