PostGreSQL and PgAdmin Installation and Setup Guide

In this section, we are going to learn how to download, install and setup the process of PostGreSQL and PgAdmin.

Objectives

◈   Install PostGreSQL

◈   Install PgAdmin

◈   Restore Database

◈   Perform Example Query

PgAdmin

◈   Graphical Interface which is used to make queries.

◈  There are two versions, 3.x and 4.x

◈   PgAdmin 4 which is the latest and stable version, it opens in browser. Even if it opens in browser it doesn't require internet.

◈   PgAdmin 3 is no longer supported, means there will be no updates by the developer of PgAdmins. It opens as a program.

PostGreSQL

◈   PostGreSQL is the actual SQL engine that stores the data and from which we are quering from.

◈   Once we will install PgAdmin and PostGreSQL, then we will connect PostGreSQL Server to PgAdmin and then we can use that graphical interface to restore a database to that server.

Download PgAdmin

◈   First we will download PgAdmin from https://www.pgadmin.org/download/

◈   Once you are on the download page, select the appropriate operating system.

◈   Once the download is finished, click on the executable file and follow the GIF below.

Download PostGreSQL

◈   Now it is time to download PostGreSQL from https://www.pgadmin.org/download/.

◈   Once you are on the download page, select the approprate operating system.

◈   Once the download is finished, click on the executable file and follow the GIF below.