[postgis-users] Win32 PostgreSQL 7.5/PostGIS snapshot available for developers

[Mark Cave-Ayland]

Hi guys,

After following all the traffic on this list about Win32 PostgreSQL, I
thought it would be a useful exercise to try and build it myself. The
result is that I now have a working snapshot which I have decided to
upload to the web to allow developers to determine how their spatial
applications may perform under Win32. The download can be found at
http://www.webbased.co.uk/mca/pgsql75win.zip and is roughly 14Mb in
size. The installation includes PostGIS CVS, PROJ 4.4.8 and GEOS CVS
taken from the end of last week.

Installation is simple: extract the ZIP file in C:\ and all the paths
should be correct. The only thing to watch out for is to make sure you
don't have another copy of libpq.dll in \WINDOWS or \WINDOWS\SYSTEM[32].
There are several scripts included to ease setting things up.

	- pgstart.bat starts the PostgreSQL server
	- env.bat starts a command line with the correct path so any of
the
	postgres executables can be run, e.g. psql.exe
	- initdb.bat performs an initdb in the C:\pgsql75win\data
subdirectory

Note that this is just a test installation we are using to evaluate
PostGIS performance under Win32 and as such it has no warranties
whatsoever. Win32 PostgreSQL development is still very much a work in
progress. Please treat it like a new toy, don't use it in production,
and there is a chance you may lose some data. However, any feedback is
gratefully received and it is hoped that it will allow many of the
Win32/PostGIS issues to be resolved before the final 7.5 release.

Finally a big thank you to Romi Hardiyanto and David Techer, without
whom this would have been a much harder job. I can also verify that
Romi's patches work satisfactorily for other developers who wish to try
a similar exercise.


Cheers,

Mark.

---

Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England

Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446


This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.