[Mapserver-users] PostgreSQL Cygwin problem

[Benjamin Wragg]

Hi Andrew,

Good news! I can replicate your problem and get the following error on
an initdb:

	creating template1 database in /var/test/base/1...
IpcSemaphoreCreate: semget(ke
	y=1, num=17, 03600) failed: Function not implemented

	initdb failed.

	Removing /var/test.

To fix it all I have to do is actaully start the ipc daemon before you
run initdb. I just looked at
http://www.gasai.com/gisapps/WindowsHowTo.html and found that it tells
you to do it after the initdb. 

So if you have setup cygipc as a service type:

	net start ipc-daemon

Of if your starting it locally type:

	ipc-daemon &

If you have problems getting this to work check that Cygwin's bin
directory (e.g., C:\Cygwin\bin) is added to the Windows NT/2000's system
PATH and the machine rebooted.

Once this is going your initdb command should work. Let me know how you
go.

Cheers,

Benjamin Wragg

	
-----Original Message-----
From: Andrew Bailey [mailto:andy at planetnomad.com] 
Sent: Thursday, 3 April 2003 8:20 PM
To: bwragg at tpg.com.au
Subject: Re: [Mapserver-users] Supported PostgreSQL Platforms and
Versions???


I was following http://www.gasai.com/gisapps/WindowsHowTo.html
And got stuck on the initdb command. i was getting that semget error.

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

The only advice 've found onliine it to replace the cygipc with the
newest version but i've done that .. many times.
I really hope you can help

Cheers,
Andy Bailey


----- Original Message ----- 
From: Benjamin Wragg 
To: 'Andrew Bailey' 
Sent: Thursday, April 03, 2003 4:20 AM
Subject: RE: [Mapserver-users] Supported PostgreSQL Platforms and
Versions???


Will do.

What type of problems are you having with Cygwin? I've had a bit of
experiance with Cygwin and my be able to help.

Cheers,

Benjamin Wragg

 -----Original Message-----
From: Andrew Bailey [mailto:andy at planetnomad.com] 
Sent: Thursday, 3 April 2003 11:24 AM
To: bwragg at tpg.com.au
Subject: Re: [Mapserver-users] Supported PostgreSQL Platforms and
Versions???


Benjamin,
Can you let me know if you hear anything or have any success in this.
I'm trying to get postgresql work with cygwin - and not having a good
time of admittedly
Andy
----- Original Message ----- 
From: Benjamin Wragg 
To: mapserver-users at lists.gis.umn.edu 
Sent: Thursday, April 03, 2003 1:59 AM
Subject: [Mapserver-users] Supported PostgreSQL Platforms and
Versions???


Hi all,

I was just reading an article entitled "PostgreSQL on Windows" at
http://techdocs.postgresql.org/guides/Windows which discusses different
ways to get PostgreSQL to run on Windows. It highlights that the
PostgreSQL project plans to add support for a native Windows version
with our 7.4 release but that the free option at present is to use
PostgreSQL running through Cygwin (http://sources.redhat.com/cygwin). It
goes on to discuss 3 products, PowerGres http://powergres.sra.co.jp,
PostgreSQL by dbExperts http://www.dbexperts.net and UltraSQL by
PeerDirect http://www.peerdirect.com which all offer native Windows
support now. 

I was wondering if anyone had experience with any of these products and
whether they will work with Mapserver and PostGIS?

Thanks

Benjamin Wragg