About Windows Experimental Binaries
As many people know who have tried to build PostGIS binaries under windows, its a time consuming process to set up the environment and generally is rocket science when compared to building under Linux. To encourage our vast and growing community of windows users to test our alpha, beta, and release candidate releases of PostGIS, we will be providing experimental binaries. These will just contain the dlls and exes you need to get going with a ReadMe.txt file to explain where to put the binaries and how to load up your database and a sample batch script to create a postgis enabled database. These are more for experienced or adventurous PostGIS users, who are too short on time or patience to build thier own binaries, but want to experiment with bleeding edge PostGIS technology.
For those who want to experience the joys and frustrations of compiling under Windows -- please refer to Compiling PostGIS under Windows.
If you run into any issues using these or come across bugs, please submit these to the PostGIS bug tracker and if you have questions, please post to the PostGIS newsgroup .
Below are links to current release candidates and beta binaries of PostGIS and WKT Raster for windows. For each please refer to the ReadMe.txt packaged with each.
PostGIS ESRI Shapefile GUI
This is packaged as a stand-alone ready to be copied into your PgAdmin III install (or run stand-alone) latest from PostGIS 2.0.0 trunk as of February 1st, 2012 (r9003). This version includes ability to import multiple shapefiles at once. It will appear as a plugin under PgAdminIII and will automatically fill in the credentials of the database you have selected in PgAdmin III.
It has support for both importing into geometry and geography tables. Note: The geography import feature works only against a PostGIS 1.5 or higher databases.
PostGIS Experimental Binaries
PostGIS 2.0.0alpha3 Binaries with Raster, Topology support + Extras (Tiger Geocoder 2010) As of February 1st, 2012 (r9003)includes GEOS 3.3.3SVN r3567, Proj 4.6.1, JSON-c 0.9, libgdal 1.9.0
(PostGIS VERSIONS prior to alpha1 (r8883) require a dump reload since postgis operators and geography in/out functions have changed or been added. We now have the 3D spatial indexes, 3D box operators, KNN GIST for 9.1, 2 raster map algebra, and raster2pgsql.exe (doesn't require python installed to load rasters anymore))
More details about what has been fixed/added can be found at PostGIS 2.0.0 and PostGIS 1.5.3/1.5.4 fixes , What is new in PostGIS 2.0, Loading Rasters PostGIS Raster support, and improved Topology support
These are 32-bit binaries so will not work on 64-bit PostgreSQL. We are working on getting 64-bit binaries out as well, but are running into some stumbling blocks. For the time being -- if you are on Windows 64-bit, you must install the 32-bit PostgreSQL to use these.
- For PostgreSQL 8.4 w/ Loader/Dumper including GUI
- For PostgreSQL 9.0 (compiled against PostgreSQL 9.0.3) w/ Loader/Dumper including GUI
- For PostgreSQL 9.1 (compiled against PostgreSQL 9.1.1 - w/ Loader/Dumper including GUI.
Also includes extensions files to install using new PostgreSQL 9.1+ CREATE EXTENSION syntax.
To install:
Edit the makepostgisdb_using_extensions.bat to your paths, etc. This will install a sample postgis database using extensions.
Then in any future database you'd like to spatially enable, run at least postgis (which contains both geometry and raster support) and optionally postgis_topology commands.
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;
PostGIS 1.5.3 official binaries have been released. 1.5.4 experimental binaries will be available soon.
More details about what has been fixed/added can be found at PostGIS 1.4.3 and PostGIS 1.5.3 fixes , What is new in PostGIS 1.5, and PostGIS geography support
Please note the PostGIS 1.4.2 has now been officially released. Latest branch of 1.4.3 Coming soon
Full details of what has been patched since PostGIS 1.4.2 release can be found at PostGIS 1.4.3 fixes
These are 32-bit binaries so will not work on 64-bit PostgreSQL. We will not be supporting PostgreSQL 9.0 on Windows for the PostGIS 1.4 releases.
- For PostgreSQL 8.3 -- contains GEOS 3.2.0, Proj 4.6.1, PostGIS 1.4.3 coming soon
- For PostgreSQL 8.4 -- contains GEOS 3.2.0, Proj 4.6.1, PostGIS 1.4.3 coming soon
WKT Raster Experimental Binaries (for PostGIS 1.4+, PostGIS 1.5+) As Of August 29, 2010 Last Release - all future raster support is integrated in PostGIS 2.0.0
For details about the WKT Raster project check out WKT Raster , What is planned and completed for the WKT Raster 0.1.6 milestone? and WKT Raster Reference page
- For PostgreSQL 8.3/PostGIS 1.4+, PostGIS 1.5+ -- contains WKT Raster dll (wktraster-0.1.6d), python Raster GDAL loader files, and libgdal.dll (1.8 dev)
- For PostgreSQL 8.4/PostGIS 1.4+, PostGIS 1.5+ -- contains WKT Raster dll (wktraster-0.1.6d), python Raster GDAL loader files, and libgdal.dll (1.8 dev)
- For PostgreSQL 9.0 (comiled against PostgreSQL 9.0 beta 4)/PostGIS 1.5+ -- contains WKT Raster dll (wktraster-0.1.6d), python Raster GDAL loader files, and libgdal.dll (1.8 dev)
Maintainers
Leo Hsu
Regina Obe