• Install Postgres 11 On Windows 109
• Install Postgres 11 On Windows 100
• Install Postgres 11 On Windows 10 Pro
• Install Postgres 11 On Windows 10 Download
• Install Postgres 11 On Windows 10 64-bit

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. Postgres Installer. Postgres Installer from 2ndQuadrant is a point-and-click GUI installer developed for a number of popular platforms including Windows, macOS, and many variants of Linux. With its user-friendly interface, it provides a standalone installation for PostgreSQL versions 13, 12, 11, 10, 9.6 and 9.5.

PostGIS is a free and open-source database solution to store your GIS datasets. It utilize the power of PostgreSQL database server. Actually, the PostGIS is a spatial plugin for PostgreSQL that enables us to save or store spatial datasets in the database. We can then connect and open the spatial data from various GIS software such as QGIS, MapInfo or ArcGIS Pro. In this article, we will install PostGIS on Windows 10. We will install the latest version of PostgreSQL 13 and then install PostGIS on top of it.

Steps to install PostGIS on Windows 10

Step 1. 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.

Step 2. Install PostgreSQL Database on Windows 10

Install Postgres 11 On Windows 109

Now you have the installer and we are ready to install the PostgreSQL server. Double-click the file postgresql-13.xxx.exe. Below are the steps of the PostgreSQL 13 installation.

Install Postgres 11 On Windows 100

The installation process will take sometimes. Be patient and make sure there is no errors. At the end of the installation, you will be asked to run Stack Builder. I would recommend you to run this program so we can install PostGIS.

Installing PostGIS using Stack Builder

Select the PostgreSQL Server from the list and click Next.

Select PostGIS from the list under the Spatial Extensions. Also, you may need to install psqlODBC as well.

Specify the download directory. The Stack Builder will download some files from the internet to the download directory.

Choose PostGIS as well as Create spatial database to create a new spatial database. Click Next

During the process, you will be asked to enable some features. Please select it as you need. I would recommend to enable them if this is your first time installing PostGIS.

Press Finish to complete the installation. Now we need to change some settings on the PostgreSQL Server so it is accessible from the network.

Make PostgreSQL Accessible for the Network Users

In order to be able to connect to the PostgreSQL server from the network, we need to make sure that our settings is correct. The file to check are pg_hba.conf file as well as postgresql.conf.

postgresql.conf

In Windows 10, the default location for the file postgresql.conf file is inside C:Program FilesPostgreSQL13data folder. Open it using notepad. And then find the following line

Make sure that line is not commented. In most cases, we do not need to change anything here.

pg_hba.conf

The pg_hba.conf file is located inside C:Program FilesPostgreSQL13data folder. Using notepad again, to open this config file. At the end of this file, add the following line

Change the IP address with your network IP address.

Now restart PostgreSQL Server from the System Service window as follow. Right-click the postgresql-x64-13 and choose restart.

Configure Firewall

The next step is to configure the Windows firewall to allow incoming connection through port 5432 (PostgreSQL default port. You may need to adjust the settings if you use different port).

Open Windows Defender Firewall with Advanced Security and then click Inbound Rules. Click New Rule to create a new firewall rule

Select port from the list as follow and then click Next.

Select TCP and then type the PostgreSQL port. In this case, I use the default port for PostgreSQL which is 5432

Click Next and choose Allow Connection

Select the network profile you want to apply this new rule.

Finally, give a new name for the rule and click Finish.

Done. Now you should be able to connect to the PostgreSQL server from your network.

Interactive installer by EDB

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

Install Postgres 11 On Windows 10 Pro

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 10 Download

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.

Platform support

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 10 64-bit