Steps to install PostGIS on Windows 10. Download PostgreSQL 13 for Windows. Navigate to the link below to download PostgreSQL 13 binary installer. Select the Windows version from the list and the download process will start automatically. Install PostgreSQL Database on Windows 10. PgAgent is a job scheduler for PostgreSQL which may be managed using pgAdmin. Prior to pgAdmin v1.9, pgAgent shipped as part of pgAdmin. From pgAdmin v1.9 onwards, pgAgent is shipped as a separate application.

These instructions are for PostgreSQL 9.1 and higher, PostGIS 2.2 and higher that is compiled with raster support.Note: if you have postgis, without raster support, you can not use CREATE EXTENSION. Refer to PostGIS install.

Enabling PostGIS

PostGIS is an optional extension that must be enabled in each database you want to use it in before you can use it. Installing the software is just the first step.DO NOT INSTALL it in the database called postgres.

Connect to your database with psql or PgAdmin. Run the following SQL.You need only install the features you want:

Upgrading PostGIS

To upgrade PostGIS, you first have to install the latest binaries and then upgrade each database you have PostGIS installed in

For example connect to database you want to upgrade and if you just installed binaries for 2.1.3You can upgrade from 2.0 to 2.1, 2.2 et.c using this approach. To go from 1.* to 2.* you need to do a hard upgrade.Refer to PostGIS install for more extensive instructions.Note: that as of PostGIS 2.1.3 and PostGIS 2.0.6, you need to set environment variables to get full features.

or to a specific version

Spatial SQL

See the documentation for more guidance.

Interactive installer by EDB

Download the installer certified by EDB for all supported PostgreSQL versions.

Install Postgres 11 On Windows 10 Free

This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developingyour databases, and StackBuilder; a package manager that can be used to download and installadditional PostgreSQL tools and drivers. Stackbuilder includes management,integration, migration, replication, geospatial, connectors and other tools.

This installer can run in graphical or silent install modes.

Install Postgres 11 On Windows 104

The installer is designed to be a straightforward, fast way to get up and running withPostgreSQL on Windows.

Advanced users can also download azip archiveof the binaries, without the installer.This download is intended for users who wish to include PostgreSQL as part of another application installer.

Install Postgres 11 On Windows 10 64

Platform support

Install Postgres 11 On Windows 10 Pro

The installers are tested by EDB on the following platforms. They can generally be expected to run on other comparable versions:

Install Postgres 11 On Windows 100

PostgreSQL Version	64 Bit Windows Platforms	32 Bit Windows Platforms
13	2019, 2016
12	2019, 2016, 2012 R2
11	2019, 2016, 2012 R2
10	2016, 2012 R2 & R1, 7, 8, 10	2008 R1, 7, 8, 10
9.6	2012 R2 & R1, 2008 R2, 7, 8, 10	2008 R1, 7, 8, 10