PostGIS
Spatial and Geographic objects for PostgreSQL
Released Versions
Latest released version is PostGIS 2.0.3 (for PostgreSQL 8.4-9.2 32-bit and 9.0-9.2 64-bit) is on Stackbuilder and also available at PostGIS Windows download. Package includes:
- PostGIS 2.0.3 with raster support
- Tiger geocoder (in contrib/postgis-20/extras folder)
- For 9.1-9.2 - extensions files
- Commandline raster loader, shapefile import/export: raster2pgsql, shp2pgsql, pgsql2shp
- GUI: shp2pgsql-gui which has both import and export support for geometry/geography
Warning: There was a bug in packaging of all the 64-bit and the PostgreSQL 9.2 (both 32-bit and 64-bit). If you installed a version of PostGIS 2.0.3 without a -2.exe or -2.zip you should reinstall again or replace the bin/shp2pgsql,pgsql2shp,raster2pgsql (and lib/postgis.dll, lib/rtpostgis.dll) with the one in the -2.zip available on PostGIS Windows download.
The simplest way to get PostGIS on Windows is using the EnterpriseDB build and StackBuilder. Refer to An Almost Idiot’s Guide Installing PostGIS on Windows
- Download and install PostgreSQL from EnterpriseDB.
- Run the “StackBuilder” utility and install the PostGIS add-on.
- The version of PostGIS included in StackBuilder might not be the very very latest stable
because the binaries are created before the installers are available. You can get the latest PostGIS to install into the Windows EnterpriseDB build of PostgreSQL.
- Download and install the appropriate PostGIS installer for your PostgreSQL version from the PostGIS Windows download site. If you are running PostgreSQL 64-bit, make sure to use a package with 64 in the name. The ones not noted or with w32 are for PostgreSQL 32-bit. If you are using PostgreSQL 32-bit on a 64-bit windows, you will need to use the 32-bit package.
- You can also get bleeding edge of the latest versions from our build servers described in next column. Use at your own risk.
- You can also get a combined PostgreSQL / PostGIS / GeoServer install by downloading the OpenGeo Suite (registration required). The PostGIS version may not be the latest.
If you want to use the zip, setup, and setup source files directly they are available:
Zip and Installer files The .zip files are just the binaries you can copy into your PostgreSQL installation and then enable in each database as usual. The exe are standard windows setup for both 32-bit and 64-bit PostgreSQL.
Source Setup files The source setup files are useful if you want to build your own NSIS installer or create a single setup for your own project that also installs PostGIS. The Binary zip files should contain all the binary files you need to customize your own setup minus the documentation. You can also just extract the .exe setup file to get the binaries, but the extract sometimes gets mangled leaving out some of the postgis-gui subfolders.
Unreleased Versions
If you are more adventurous, and risk-seeking you can partake in our experimental windows binaries built automatically by Winnie whenever there is a change in any of the 2.0 and 2.1 branches. These are especially useful for testing out new features or if you are badly in need of a bug fix that has not been released yet.
If you don’t want to risk messing up an existing windows install or aren’t allowed to write to the registry , we’d suggest using the companion PostgreSQL EDB zip binaries which don’t require installation. Setup is detailed in Starting PostgreSQL in windows without install.
Windows: Winnie Bot Experimental Builds
- PostgreSQL 9.3 32-bit, 64-bit compiled against PostgreSQL 9.3 beta1
- PostgreSQL 9.2 32-bit, 64-bit (also pgrouting 1.07dev will work for PostGIS 2.0 and 2.1)
- PostgreSQL 9.1 64-bit
- PostgreSQL 9.0 64-bit
PostGIS 2.1.0beta2
Packaged
- GEOS 3.4.0Dev, GDAL 1.10.0, Proj 4.8.0
- raster2pgsql raster loader
- GUI and Commandline loader/exporters
- Tiger Geocoder (2011/2012 loader) + extension files
- Extension files for PostgreSQL 9.1+
PostGIS 2.0.4SVN
Packaged
- GEOS 3.3.9Dev, GDAL 1.9.2, Proj 4.8.0
- raster2pgsql raster loader
- GUI and Commandline loader/exporters
- Tiger Geocoder (2010 loader)
- Extension files for PostgreSQL 9.1+
PostGIS ..
pgRouting Package 2.0.0dev
Only for PostgreSQL 9.1 (64-bit), 9.2 (32-bit /64-bit), 9.3beta1 (32-bit / 64-bit)
Will work with PostGIS 2.0 or 2.1
- pgRouting 2.0.0dev
- compiled with CGAL 3.9 (this dependency may be removed before release)
- compiled with boost 1.46
- Extension files for PostgreSQL 9.2+
- Dijkstra algorithm - Shortest path algorithm
- A-star (A*) algorithm - Shortest path algorithm using heuristical function
- Driving distance - area person can cover in certain time from start point using road network
- TSP Travelling Salesman Problem solution
- Shooting star (Shooting*) algorithm - Shortest path algorithm for real road networks with turn restrictions, traffic lights and one way streets.
PostGIS ..
pgRouting Package 1.0.7dev
Only for PostgreSQL 9.2 (32-bit /64-bit)
Will work with PostGIS 2.0 or 2.1
- pgRouting 1.0.7dev
- Extension files for PostgreSQL 9.2+
- compiled with CGAL 3.9
- compiled with boost 1.46
- Dijkstra algorithm - Shortest path algorithm
- A-star (A*) algorithm - Shortest path algorithm using heuristical function
- Driving distance - area person can cover in certain time from start point using road network
- TSP Travelling Salesman Problem solution
- Shooting star (Shooting*) algorithm - Shortest path algorithm for real road networks with turn restrictions, traffic lights and one way streets.
Installing Experimental Binaries
- Copy the contents of the respective zip file to your PostgreSQL install and when prompted to overwrite, overwrite
- If you are experimenting with both 2.0 and 2.1, make sure to use the GEOS from 2.1 which is newer 3.4.0dev.
- The newer GEOS will work with older 2.0, but 2.1 will only work with GEOS 3.4.0+
Enabling PostGIS
PostGIS is an optional extension that must be enabled in EVERY database you want to use it in. If you are running PostgreSQL 9.1+ you can use:
CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; CREATE EXTENSION postgis_tiger_geocoder;
postgis_tiger_geocoder extension file option only available for PostGIS 2.1+.
If you are running PostgreSQL 9.2 and have installed PostGIS 2.0 or 2.1 (you can download and extract into your PostgreSQL install folder the pgRouting 1.07dev package and do)
CREATE EXTENSION pgrouting;
See the install section for more guidance.