Re: Problem with initdb failing

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(at)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(at)mverify3 ~
$ ipc-daemon2 &
[1] 2704

paul_sand(at)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(at)mverify3 ~
$ postmaster -D /usr/AMATE/data6 &

paul_sand(at)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(at)mverify3 ~
$ ipc-daemon2 &
[1] 2704

paul_sand(at)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(at)mverify3 ~
$ postmaster -D /usr/AMATE/data6 &
[1] 1836

paul_sand(at)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(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org] On Behalf Of Jason Tishler
Sent: Friday, October 31, 2003 7:49 AM
To: Paul R. Sand
Cc: pgsql-cygwin(at)postgresql(dot)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