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