How to Download and Install PostgreSQL on Windows

How to Download and Install PostgreSQL on Windows



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 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.
Following is step by step process to install Postgre in Windows Machine:
Step 1) Go to https://www.postgresql.org/download and select Windows
Step 2) You are given two options
1. Interactive Installer by EnterpriseDB
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
Step 3)
  1. You will be prompted to desired Postgre version and operating system. Select the latest Postgre version and OS as per your environment
  2. Click the Download Button
Download will begin
Step 4) Open the downloaded exe and Click next on the install welcome screen.
Step 5)
  1. Change the Installation directory if required, else leave it to default
  2. Click Next
Step 6)
  1. Click Next
Step 7)
  1. You may change the data location
  2. Click Next
Step 8)
  1. Enter super user password. Make a note of it
  2. Click Next
Step 9)
  1. Leave the port number default
  2. Click Next
Step 10)
  1. Check the pre-installation summary:
  2. Click Next
Step 11) Click the next button
Step 12) 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
Step 13) To launch Postgre go to Start Menu and search pgAdmin 4
Step 14) You will see pgAdmin homepage
Step 15) Click on Servers > Postgre SQL 10 in the left tree
Step 16)
  1. Enter super user password set during installation
  2. Click OK
Step 17) You will see the Dashboard

That's it to Postgre SQL installation.
Reactions

Post a Comment

0 Comments