Subject: Re: postgres 7.3 IpcSemaphoreCreate: semget(key=1, num=17, 03600)failed: Function not implemented
From: Dan Holmsand <[email-masked]>
To: [email-masked]
Date: Mon, 09 Dec 2002 19:34:59 +0100

Jason,

Jason Tishler wrote:
> On Mon, Dec 09, 2002 at 12:05:16AM +0100, Dan Holmsand wrote:
> 
>>I get a similar error:
>>
>>IpcSemaphoreInitialize: semctl(id=2, 0, SETVAL, 0) failed: Invalid argument
> 
> 
> The above is noted in the README:
> 
>     2. It is recommended to delete all cygipc temporary files
>     (/tmp/cygipc* and /tmp/MultiFile*) before starting postmaster under
>     a different user account.  Otherwise, postmaster will fail to start
>     due to IPC errors.

I know. However, this doesn't necessarily help if ipc-daemon is run by 
one account (say, "system" or "administrator") and postmaster by another 
(say, "postgres"). In my experience at least, postgres must have read 
AND write rights to the /tmp/MultiFile* files, otherwise you get the 
above error on startup.

That is not entirely clear in the README, imho.

/dan

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/