How to Download & Install PostgreSQL for Windows [17 Steps]

To use Postgre in your machine, you need to install:

  1. Postgre Database Server
  2. A graphical tool to administer and manage the DB. pgAdmin is the most popular tool GUI Tool for Postgre

You could individually Download PostgreSQL for Windows and install these components but coupling the settings between the DB server, and a GUI tool could be a challenge. It’s best to use a bundled installer which takes care of configuration complexities.

How to Download & Install PostgreSQL

Following is a step by step process on How to Install PostgreSQL on Windows Machine:

Step 1) Open your browser.
Go to https://www.postgresql.org/download and select Windows

Download and Install PostgreSQL

Step 2) Check options.
You are given two options 1) Interactive Installer by EnterpriseDB and 2) Graphical Installer by BigSQL.

BigSQL currently installs pgAdmin version 3 which is deprecated. It’s best to choose EnterpriseDB which installs the latest version 4

Download and Install PostgreSQL

Step 3) Select PostgreSQL version.

  1. You will be prompted to desired PostgreSQL version and operating system. Select the latest PostgreSQL version and OS as per your environment
  2. Click the Download Button

Download and Install PostgreSQL

Download will begin

Download and Install PostgreSQL

Step 4) Open exe file.
Once you Download PostgreSQL, open the downloaded exe and Click next on the install welcome screen.

Download and Install PostgreSQL

Step 5) Update location.

  1. Change the Installation directory if required, else leave it to default
  2. Click Next

Download and Install PostgreSQL

Step 6) Select components.

  1. You may choose the components you want to install in your system. You may uncheck Stack Builder
  2. Click Next

Download and Install PostgreSQL

Step 7) Check data location.

  1. You may change the data location
  2. Click Next

Download and Install PostgreSQL

Step 8) Enter password.

  1. Enter super user password. Make a note of it
  2. Click Next

Download and Install PostgreSQL

Step 9) Check port option.

  1. Leave the port number default
  2. Click Next

Download and Install PostgreSQL

Step 10) Check summary.

  1. Check the pre-installation summary:
  2. Click Next

Download and Install PostgreSQL

Step 11) Ready to install.
Click the next button.

Download and Install PostgreSQL

Step 12) Check stack builder prompt.
Once install is complete you will see the Stack Builder prompt

  1. Uncheck that option. We will use Stack Builder in more advance tutorials
  2. Click Finish

Download and Install PostgreSQL

Step 13) Launch PostgreSQL.
To launch PostgreSQL go to Start Menu and search pgAdmin 4

Download and Install PostgreSQL

Step 14) Check pgAdmin.
You will see pgAdmin homepage.

Download and Install PostgreSQL

Step 15) Find PostgreSQL 10.
Click on Servers > PostgreSQL 10 in the left tree

Download and Install PostgreSQL

Step 16) Enter password.

  1. Enter super user password set during installation
  2. Click OK

Download and Install PostgreSQL

Step 17) Check Dashboard.
You will see the Dashboard

Download and Install PostgreSQL

That’s it to PostgreSQL installation.

Also learn more about How to Install PostgreSQL on Ubuntu