Re: Initdb fails... Again!

Поиск
Список
Период
Сортировка
От Jason Tishler
Тема Re: Initdb fails... Again!
Дата
Msg-id 20030117161703.GE2044@tishler.net
обсуждение исходный текст
Ответ на Re: Initdb fails... Again!  ("Markko Paas" <Markko@softronic.ee>)
Список pgsql-cygwin
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

В списке pgsql-cygwin по дате отправления:

Предыдущее
От: "Igor Georgiev"
Дата:
Сообщение: Windows console for PostgreSQL released
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Postgres 7.3 from source --with-tcl : Errors again...