If you need help using these packages (the installers and buildbot binaries), please ask on our users mailing list.

If you find a bug with the installers or the buildbot packages, please report these on our Ticket Tracker under component: build/upgrade/install with keyword: windows.

The installers are designed to work with EnterpriseDb PostgreSQL distributions. If you are using BigSQL distribution use the PostGIS available via the BigSQL distribution. If you are on BigSQL (PostgreSQL 9.5+) and need items not available in BigSQL distribution (e.g. SFCGAL, pgRouting, or development versions of PostGIS), you can use the binaries in the experimental section. Note the path you copy to in BigSQL is a little different (e.g. postgresql/lib instead of lib).

If you need SFCGAL support, you need to use the PostGIS packaged in the zips in the experimental section instead of the BigSQL PostGIS. Also make sure not to overwrite any files that come with BigSQL distribution.

Make sure you are using PostgreSQL 9.5.2+ or PostgreSQL 9.4.7+ or PostgreSQL 9.6/10+. These may not work with lower PostgreSQL micros.

Released Versions

PostGIS 2.4.1 came out October 18th, 2017. Binaries for versions of PostgreSQL 9.4-10 (64-bit, 32-bit) (and installers for 10/9.6 64-bit and 9.6 32-bit) are currently available in Unreleased PostGIS Versions section. Installers 9.6 64/32-bit are available on stackbuilder. PostgreSQL 10 users will need to upgrade to PostgreSQL 10.1 and reboot in order to see the Spatial Extensions section in Stack Builder.

PostGIS 2.4.1 bundle includes:

PostGIS 2.3.3 came out July 1st, 2017. Binaries are currently available in experimental section for versions of PostgreSQL 9.3-9.6 (64-bit, 32-bit). Installers are available for PostgreSQL 9.6 and 9.5 64/32-bit.

The installers are designed to work with EnterpriseDb PostgreSQL distributions. If you are using BigSQL distribution use the PostGIS available via the BigSQL distribution. If you are on BigSQL (PostgreSQL 9.5+) and need items not available in BigSQL distribution (e.g. SFCGAL, pgRouting, or development versions of PostGIS), you can use the binaries in the experimental section. Note the path you copy to in BigSQL is a little different (e.g. postgresql/lib instead of lib).

If you need SFCGAL support, you need to use the PostGIS packaged in the zips in the experimental section instead of the BigSQL PostGIS. Also make sure not to overwrite any files that come with BigSQL distribution.

Make sure you are using PostgreSQL 9.5.2+ or PostgreSQL 9.4.7+ or PostgreSQL 9.6.0+. These may not work with lower PostgreSQL micros.

PostGIS 2.3.3 bundle includes:

Installers are available for PostGIS 2.2.2 for PostgreSQL 9.5 32/64-bit, PostgreSQL 9.4 64-bit (binaries in experimental for PostgreSQL 9.2-9.5 both 32 and 64-bit)

Make sure you are using PostgreSQL 9.5.2+ or PostgreSQL 9.4.7+ or PostgreSQL 9.6.0+. These may not work with PostgreSQL lower micros.

Installers are available for PostGIS 2.1.8 for PostgreSQL 9.2 (64-bit), PostgreSQL 9.4 (32/64-bit) (via Application stackbuilder) and windows download. NOTE: the PostgreSQL 9.2 PostGIS 2.1.8 installers and binaries require PostgreSQL 9.2.9 or above. If you had done a micro upgrade from a pre-PostgreSQL 9.2.9 and your PostGIS or pgRouting broke, you need to install this version.

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 Stable or 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.

Binaries from PostgreSQL 9.5 and up will work on both PostgreSQL EDB windows distribution as well as the BigSQL distributions.

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.

Or Alternatively if you have windows 64-bit, you also have the option of BigSQL development installs - Installing BigSQL PostgresQL version with PGC

PostgreSQL EDB 9.4+ will not work with Windows XP, so if you have Windows XP, use PostgreSQL 9.3

Windows: Winnie Bot PostGIS and pgRouting Experimental Builds

PostGIS 2.5.0dev

Packaged


PostGIS 2.4.2dev

Packaged


PostGIS 2.3.5dev

Packaged


PostGIS 2.2.6dev

Packaged


PostGIS 2.1.9dev

Packaged


PostGIS 2.0.6

Packaged


PostGIS ..

pgRouting Package 2.5.2

For 10 (32-bit / 64-bit), 9.6 (32-bit / 64-bit), 9.5(32-bit / 64-bit), 9.4 (32-bit / 64-bit), 9.3 (32-bit /64-bit) refer to getting started guide for more details.

Also find in same folder companion osm2pgrouting-2.2.0 package for loading osm data.

Will work with PostGIS 2.1-2.5 (not tested on PostGIS 2.0, but should work)


PostGIS ..

pgRouting Package 2.2.3

For 9.6beta1 (32-bit / 64-bit), 9.5(32-bit / 64-bit), 9.4 (32-bit / 64-bit), 9.3 (32-bit /64-bit), 9.2 (32-bit / 64-bit) refer to getting started guide for more details.

Also find in same folder companion osm2pgrouting-2.1.0 package for loading osm data.

Will work with PostGIS 2.1 or 2.2 or 2.3dev (not tested on PostGIS 2.0, but should work)


PostGIS ..

pgRouting Package 2.4.2dev

For 10 (32-bit / 64-bit), 9.6 (32-bit / 64-bit), 9.5(32-bit / 64-bit), 9.4 (32-bit / 64-bit), 9.3 (32-bit /64-bit), 9.2 (32-bit / 64-bit) refer to getting started guide for more details.

Also find in same folder companion osm2pgrouting-2.2.0 package for loading osm data.

Will work with PostGIS 2.1-2.4 (not tested on PostGIS 2.0, but should work)

New Proposed Signatures

Deprecated Signatures

* pgr_bddijkstra - use pgr_bdDijkstra instead

Deprecated Functions

* pgr_pointsToVids

Bug fix

* Bug fixes on proposed functions
    pgr_withPointsKSP: fixed ordering
* TRSP original code is used with no changes on the compilation warnings

Improvements and consolidation of existing algorithms


PostGIS ..

pgRouting Package 2.1.0

Only for 9.5 (64-bit), 9.4 (32-bit / 64-bit), 9.3 (32-bit /64-bit), 9.2 (32-bit /64-bit) refer to getting started guide for more details

Will work with PostGIS 2.1 or 2.2 (not tested on PostGIS 2.0, but might work)


PostGIS ..

pgRouting Package 2.0.1

Only for 9.2 (32-bit /64-bit), 9.3 (32-bit /64-bit), 9.4 (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 postgis_sfcgal;
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 package and do)

CREATE EXTENSION pgrouting;

For loading OpenStreetMap data (OSM) into pgrouting format, you can use osm2po or osm2pgrouting. Windows binaries for osm2pgrouting can be found in the 9.4 extras folder and should work fine with 9.3 or 9.4 installs. Make sure to use the 32-bit with 32-bit PostgreSQL install and 64-bit for PostgreSQL 64-bit install (copying the .dlls into your respective PostgreSQL/bin folder). Instructions for install and loading data are provided in the included readme.

If you are running PostgreSQL 9.3 (x64,x32) or 9.4 (x32, x64) and have installed PostGIS 2.2.0dev (you have the sfcgal extension for advanced 3D support)

CREATE EXTENSION postgis_sfcgal;
ALTER DATABASE your_db_here 
 SET postgis.backend = sfcgal;

See the install section for more guidance.