Re: Initdb fails... Again!

Markko,

On Fri, Jan 17, 2003 at 09:03:20AM +0200, Markko Paas wrote:
> Thank you for quick feedback!

You are welcome.

> Ipc-daemon is running as a service - an excerpt from ps -a -W

Good.

> PostgreSQL version is 7.3.1-1

Good.

> But ipctest fails!

Bad.  If ipctest fails, then so will PostgreSQL. :,(

> $ ipctest s
> Test v0.03
> Unable to create semaphore
> semget : Function not implemented

My WAG is a permissions problem.  What do you get when you run the
following?

    $ ls -ld /tmp /tmp/cygipc_* /tmp/MultiFile*
    drwxrwxrwx+ 101 Administ None       176128 Jan 17 10:56 /tmp
    -rw-rw-rw-    1 SYSTEM   SYSTEM    3916520 Jan 13 15:32 /tmp/MultiFileMsg
    -rw-rw-rw-    1 SYSTEM   SYSTEM      22032 Jan 13 15:32 /tmp/MultiFileSem
    -rw-rw-rw-    1 SYSTEM   SYSTEM     202768 Jan 13 15:32 /tmp/MultiFileShm
    -rw-------    1 jt       None      1441792 Jan 13 16:30 /tmp/cygipc_0

If /tmp is less than 777, then make it so and delete /tmp/MultiFile*.
Does this help?

BTW, are you running ipc-daemon with "--tight-security"?  If so, then do
not run with this option because it seems to prevent IPC from working
across different user accounts:

    $ id
    uid=18(SYSTEM) gid=18(SYSTEM) groups=544(Administrators)
    $ ipc-daemon --tight-security &
    $ ipctest s
    Test v0.03
    semaphore 0 created

    $ id
    uid=1000(jt) gid=513(None) groups=513(None),544(Administrators),...
    $ ipctest s
    Test v0.03
    Unable to create semaphore
    semget : Function not implemented

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