Postgres Pro
Downloads
Home   >   mailing lists

Thread: Windows XP SP1, PostgreSQL 7.2.4, Cygwin 1.3.22, CygIPC 1.14-1

Windows XP SP1, PostgreSQL 7.2.4, Cygwin 1.3.22, CygIPC 1.14-1

From
Patrick Bakker
Date:

If google and mailing lists around the world are correct I'm not alone in finding Cygwin/PostgreSQL to be an extremely frustrating experience. Hopefully somebody here can help.

So after much poking around I eventually determined that the latest Cygwin setup installs experimental Cygwin DLLs and an experimental ipc-daemon2 which PostgreSQL 7.2.4 apparently does not recognize. So I cleared out everything and reinstalled Cygwin choosing the stable version and installed CygIPC 1.14 by hand.

Then to test the IPC portion of things I did:

cygrunsrv --install ipc-daemon --desc "Cygwin IPC Daemon" --path /usr/local/bin/ipc-daemon --termsig INT --shutdown

chmod 777 /tmp
rm -rf /tmp/Multi*

net start ipc-daemon

All goes well.

"ipctest s 20" returns
1 semaphore created

Then to clear out anything I might have changed running the test I did.

net stop ipc-daemon
rm -rf /tmp/Multi*
net start ipc-daemon

Now when I run initdb -D /usr/share/postgresql/data I get the following error:

IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: function not implemented

So at this point, based on a cryptic hint I read somewhere, I downloaded the latest cygwin snapshot (Sept 1) and manually updated /usr/bin/cygwin1.dll to this version and reran the above.

Same problem.

The only problem I have that is out of place according to the 15 different instruction lists on the web is that I am doing this all under my Patrick username. I successfully created a postgres local user on my XP machine and added it /etc/passwd and gave it permission to log on as a service but I cannot log into the account under Cygwin. My Patrick account is under a VANBELLE domain and I wonder if this has something to do with it (ie. looking for postgres in VANBELLE domain by default?). This only matters though if it is critical to run PostgreSQL as the postgres user which I can't understand why it would be. Additionally the 7.2.4 README for Cygwin says psql can run under any account. Therefore I assumed that initdb can also.

Anybody have any thoughts?

Patrick

Re: Windows XP SP1, PostgreSQL 7.2.4, Cygwin 1.3.22, CygIPC 1.14-1

From
Jason Tishler
Date:
Patrick,

On Tue, Sep 02, 2003 at 03:05:10PM -0700, Patrick Bakker wrote:
> If google and mailing lists around the world are correct I'm not alone
> in finding Cygwin/PostgreSQL to be an extremely frustrating
> experience.

Hmm...

> [snip]
>
> Anybody have any thoughts?

Try again with the latest versions:

    cygipc                  2.01-2
    cygwin                  1.5.3-1
    postgresql              7.3.4-2

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