Windows both 32-bit and 64-bit PostGIS 2.0.0 are up on application stack builder.
we'll be updating our almost Idiot's guide in another week or so to show installing PostGIS 2.0. We also have fairly recent builds of upcoming PostGIS 2.0.1SVN and PostGIS 1.5.4SVN
in
PostGIS windows experimental builds section, which includes an updated GEOS 3.3.4dev to handle GEOS related bugs. Fixed items are itemized in
PostGIS 2.0.1 SVN.
So if you are bitten by any of these you might want to replace with at least the latest binaries available in the
Windows experimental builds
Now that PostGIS 2.0.0 is finally out, the number one question people have (or should have) is how to upgrade your PostGIS install to the
latest 2.0. We've seen a few casualities on the PostGIS users list of people who did it wrong partly because how you do it has changed a bit. Some ground rules, if you are running 1.x, you MUST do a hard-upgrade
and if you go the quick and dirty hard-upgrade path, you MUST run the postgis_upgrade_20_minor.sql and rtpostgis_upgrade_20_minor.sql (if you installed raster support from an early 2.0 build or wktraster).
If you are running an alpha of PostGIS 2.0, you can possibly get by with a soft-upgrade with caveats. Now for the long story.
- Figure out what you are running by doing a:
SELECT postgis_full_version();
- If you are running PostGIS 2.0.0 beta2 (technically you could do a micro upgrade if you have alpha1 or above but there were some operator changes with geography that require a dump/restore to take advantage of) or above follow the micro upgrade route otherwise Please follow one of the hard upgrade routes. There are a few upgrade
routes in fact, so choose which ever seems less scary.
Continue reading "How to upgrade your database to PostGIS 2.0 let me count the ways"