Released Versions

PostGIS 2.1.2 bundle includes

  1. Download and install PostgreSQL from EnterpriseDB.
  2. 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.
  3. 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.
  4. You can also get bleeding edge of the latest versions (or latest for older 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:

Unreleased PostGIS Versions

If you are more adventurous, and risk-seeking you can partake in our experimental windows binaries of PostGIS built automatically by Winnie whenever there is a change in any of the PostGIS 2.0, 2.1 Stable or 2.2 development 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 binaries-only binaries which don’t require installation. Setup is detailed in Starting PostgreSQL in windows without install.

Windows: Winnie Bot PostGIS and pgRouting Experimental Builds

PostGIS 2.2.0dev

Packaged


PostGIS 2.1.3dev

Packaged


PostGIS 2.0.6SVN

Packaged


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) refer to getting started guide for more details

Will work with PostGIS 2.0 or 2.1


Installing Experimental Binaries

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. packaged with PostGIS 2.1+:

CREATE EXTENSION postgis;
CREATE EXTENSION address_standardizer;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION postgis_topology;
CREATE EXTENSION postgis_tiger_geocoder;
 

postgis_tiger_geocoder and address_standardizer extension file option only available for PostGIS 2.1+ and PostgreSQL 9.1+.

If you are running PostgreSQL 9.2 or higher and have installed PostGIS 2.0 or 2.1 (you can download and extract into your PostgreSQL install folder the pgRouting 2.0dev package and do)

CREATE EXTENSION pgrouting;
 

See the install section for more guidance.