PostGIS
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage
  1. Home
  2. /
  3. Documentation
  4. /
  5. Getting Started
  6. /
  7. Installing on windows
  8. /
  9. Latest Released Version

Latest Released Version

PostGIS 3.5.0 came out September 26th, 2024. Windows PostGIS Bundle 3.5.0 installer for PostgreSQL 17 was released September 28th, 2024. On October 20th 2024, PostgreSQL 17 3.5.0 bundle was rereleased with updates for pgRouting (from 3.6.2 to 3.6.3) and mobilityDb 1.2.0rc1 to 1.2.0. PostGIS Bundle 3.5.0 for 13-16 also release on October 20th 2024.

Binaries for versions of PostgreSQL 12-17 (64-bit) available in Unreleased PostGIS Versions and OSGeo downloads). Installers for 13-17(64-bit) available on OSGeo downloads and application stackbuilder.

PostGIS 3.5.0 bundle includes:

  • PostGIS 3.5.0 with MVT support, with raster, GEOS 3.13.0, PROJ 8.2.1, SFCGAL support (1.5.2), address_standardizer, topology

  • PostGIS Tiger geocoder extension - Tiger 2023

  • pgRouting 3.6 pgRouting 3.6.3

  • 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.5 - 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_encoding option and utility functions ogr_fdw_drivers(), ogr_fdw_version(). Changes in 1.1.5 include improved date handling and support of GDAL list types mapping to PostgreSQL array types.

  • GDAL 3.9.2 with OpenJPEG 2.5.20 (JPEG 2000), ODBC, Curl, SQLite3 (for GeoPackage and OSM support), excel (XLS) (via FreeXL 1.0.6), libreoffice, XLSX spreadsheet (via expat), Arrow 13.0 for Arrow, Parquet, and GeoParquet support (used by both PostGIS raster and ogrfdw)

  • pgpointcloud 1.2.5 for querying LIDAR point cloud and in/out functions to convert to PostGIS geometry

  • h3-pg 4.1.3 for using Uber h3 api and converting h3 index representations to postgis geometry/geography/raster (raster support is new in this release).

  • MobilityDB v1.2.0 for managing trajectories. Includes many temporal spatial types and functions for them. Refer to Enabling PostGIS Extensions: MobilityDb for guidance.

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 or watch the video Getting started with PostGIS and QGIS 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:

  • 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.