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.
PostGIS 3.3.2 came out Nov 13, 2022. Windows PostGIS Bundle 3.3.2 was released Nov 21st, 2022. Binaries for versions of PostgreSQL 11-15 (64-bit) available in
Unreleased PostGIS Versions and OSGeo downloads). Installers for 11-15(64-bit) are available on stackbuilder and OSGeo downloads.
New feature in this release is h3-pg which includes
for utilizing Uber's Hexagon indexing system within PostgreSQL.
If you are using PostgreSQL < 11, use the PostGIS 3.2.3 bundle, because PostGIS 3.3+ does not support those versions.
PostGIS 3.3.2 bundle includes:
PostGIS Tiger geocoder extension - Tiger 2022
pgRouting 3.4 pgRouting 3.4.1
Commandline raster loader (raster2pgsql), shapefile import/export (shp2pgsql,pgsql2shp)
Commandline osm2pgrouting 2.3.8 for loading data from .osm files into pgRouting routable format
GUI: shp2pgsql-gui which has both import and export support for geometry/geography
ogrfdw 1.1.3 - spatial foreign data wrapper for reading both spatial (spatial columns become postgis geometry) and non-spatial data. IMPORT FOREIGN SCHEMA support New features in 1.1 -
character_encodingoption and utility functions
GDAL 3.4.3 with OpenJPEG 2.4.0 (JPEG 2000), ODBC, Curl, SQLite3 (for GeoPackage and OSM support), excel (XLS) (via FreeXL 1.0.6), libreoffice, XLSX spreadsheet (via expat) (used by both PostGIS raster and ogrfdw)
pgpointcloud 1.2.4 for querying LIDAR point cloud and in/out functions to convert to PostGIS geometry
h3-pg 4.0.3 - this is the first PostGIS Bundle to include this feature for using Uber h3 api and converting h3 index representations to postgis geometry/geography.
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
- Download and install PostgreSQL from EnterpriseDB.
- 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:
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 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 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
- Copy the contents of the respective folders in the zip file to your PostgreSQL install and when prompted to overwrite, overwrite
- The newer GEOS will work with older PostGIS installs, but newest PostGIS will only work with the newer GEOS.
PostGIS and other extensions are optional extensions that must be enabled in EVERY database you want to use them in.
1CREATE EXTENSION postgis; 2-- in PostGIS 3, postgis_raster is a separate extension from postgis 3-- so do this in addition if you are experimenting PostGIS 3+ 4CREATE EXTENSION postgis_raster; 5 6CREATE EXTENSION postgis_sfcgal; 7CREATE EXTENSION address_standardizer; 8CREATE EXTENSION fuzzystrmatch; 9CREATE EXTENSION postgis_topology; 10CREATE EXTENSION postgis_tiger_geocoder;
PostGIS related extensions
These extensions are part of the PostGIS bundle, but you can also download the latest
If you want to use pgrouting, download the respective one for your PostgreSQL/
1CREATE EXTENSION pgrouting;
For loading OpenStreetMap data (OSM) into pgrouting format, you can use osm2po or osm2pgrouting. Windows binaries for osm2pgrouting can be found alongside pgrouting for 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).
Additional extensions included in the PostGIS Bundle, that are not part of PostGIS project
are the following. These ones you'll find in the
extras folder if you want to use not yet released versions.
1-- for querying external spatial 2-- and non-spatial data sources 3CREATE EXTENSION ogr_fdw; 4 5-- for managing pointcloud data 6CREATE EXTENSION pointcloud; 7CREATE EXTENSION pointcloud_postgis; 8 9-- for using Uber h3 indexing scheme 10CREATE EXTENSION h3; 11CREATE EXTENSION h3_postgis;
See the install section for more guidance.