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.

Released Versions

PostGIS 3.1.0 came out December 18th, 2020. Binaries for versions of PostgreSQL 9.6-13 (64-bit) available in Unreleased PostGIS Versions and OSGeo downloads), installers for 9.6-13 (64-bit) are available on stackbuilder and OSGeo downloads.

NOTE: ST_MakeValid crasher fix was released after PostGIS 3.1.0 release, you can replace your postgis-3.dll with one from PostGIS 3.1.1dev in experimental section if you need a fix before PostGIS 3.1.1 is out.

PostGIS 3.1.0 bundle includes:

The simplest way to get PostGIS on Windows for the EnterpriseDb Windows PostgreSQL distribution is using the StackBuilder. Refer to An Almost Idiot’s Guide Installing PostGIS on Windows 1. Download and install PostgreSQL from EnterpriseDB. 2. Run the “StackBuilder” utility and install the PostGIS add-on.

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.

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

Installing Experimental Binaries

Enabling PostGIS

PostGIS is an optional extension that must be enabled in EVERY database you want to use it in.

CREATE EXTENSION postgis;
-- in PostGIS 3, postgis_raster is a separate extension from postgis
-- so do this in addition if you are experimenting PostGIS 3+
CREATE EXTENSION postgis_raster;
 
CREATE EXTENSION postgis_sfcgal;
CREATE EXTENSION address_standardizer;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION postgis_topology;
CREATE EXTENSION postgis_tiger_geocoder;

If you want to use pgrouting, download the respective one for your PostgreSQL/

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 extras folder of each version. Refer to instructions in the zip. 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).

See the install section for more guidance.

PostGIS 3.1.0dev

Packaged

PostGIS 3.0.1dev

Packaged

PostGIS 2.5.4dev

Packaged

PostGIS 2.4.9dev

Packaged

PostGIS 2.3.11dev

Packaged

PostGIS ..

pgRouting Package 2.6.2

For 9.5-10 (32-bit / 64-bit), 9.6 (32-bit / 64-bit), 11 (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-3.0 (not tested on PostGIS 2.0, but should work)

PostGIS ..

pgRouting Package 3.0.0

For 9.6-13 (64-bit) refer to getting started guide for more details.

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

Will work with PostGIS 2.5-3.1

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.4.3dev

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