Download Postgresql 11 Windows

Click on the Download. Choose option Windows. Choose the download the installer option. After Clicking the Download Installer.It will redirected to another site called as Enterprise DB. Here we can see PostgreSQL Software for different versions and different operating systems. Click on the Download Option It will download the PostgreSQL.

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.1.2 came out May 21st, 2021. 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: Very important fix - Speed up for ST_Transform in PostGIS 3.1.2.

PostGIS 3.1.2 bundle includes:

Windows
  • PostGIS 3.1.2 with raster, GEOS 3.9.1, PROJ 7.1.1, SFCGAL support (1.3.8), address_standardizer, topology
  • PostGIS Tiger geocoder extension - Tiger 2019
  • pgRouting 3.2 pgRouting 3.2.0
  • Commandline raster loader (raster2pgsql), shapefile import/export (shp2pgsql,pgsql2shp)
  • Commandline osm2pgrouting 2.3.7 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.0 - spatial foreign data wrapper for reading both spatial (spatial columns become postgis geometry) and non-spatial data. IMPORT FOREIGN SCHEMA supportNew features in this release - character_encoding option and utility functions ogr_fdw_drivers(), ogr_fdw_version()

  • GDAL 3.2.3 with OpenJPEG 2.3.1 (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.0 (only the 64-bit packages have this)for querying LIDAR point cloud and in/out functions to convert to PostGIS geometry

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.

Windows Postgresql Install

If you want to use the zip, setup, and setup source files directlythey are available:

Download

Download Postgresql 11 Windows 10

  • Zip and Installer files The .zip files are just the binaries you can copy intoyour 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 projectthat 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.