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.
Installers for PostGIS 2.1.8 for PostgreSQL 9.3 will be available soon (via Application stackbuilder). PostGIS 2.1.8 binaries of PostgreSQL are available on winnie build-bot page
Installers are available for PostGIS 2.1.5 for PostgreSQL 9.2 (32bit) (via Application stackbuilder) or windows download.
PostGIS 2.1.8 bundle includes
ST_FromGeoJSON security fix
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.
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.
PostgreSQL EDB 9.4 will not work with Windows XP, so if you have Windows XP, use PostgreSQL 9.3
for PostgreSQL 9.4 32-bit, 64-bit compiled against PostgreSQL 9.4 for PostGIS 2.2 (built with SFCGAL support) (also pgrouting 2.0, 2.1) (osm2pgrouting 2.1)
for PostgreSQL 9.3 32-bit, 64-bit compiled against PostgreSQL 9.3 (also pgrouting 2.0, 2.1) (2.1, 2.2 with SFCGAL support) (osm2pgrouting 2.1)
(in extras folder:
for PostgreSQL 9.2 32-bit, 64-bit (also pgrouting 2.0/2.1 will work for PostGIS 2.0, 2.1, 2.2), (osm2pgrouting 2.1)
pgRouting Package 2.1.0
Only for 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)
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
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;
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.