7985 Views
2 minutes read
Categories
Microsoft 365

Install PostgreSQL for Windows and restore database using GUI

PostgreSQL is of the most popular open source database around the market for quite some time. Though designed for UNIX/Linux platform, setting up a PostgreSQL for Windows server platform might be a challenge at time.

Here is a simple tutorial to help you get started with creating a Database Server free.

Steps:

  • Download GUI installer for PostgreSQL
  • Install PostgreSQL GUI
  • Connect to Database
  • Create a New Database
  • Restore Database

Download PostgreSQL:

  • Go to http://www.postgresql.org/download/
  • Click on Windowst1
  • Click on Download the installer from EnterpriseDB for all supported versionst2
  • Chose the correct version you are looking for (here I have considered postgresql-9.3.4-3-windows-x64)t3

PostgreSQL Installation:

  • Right click on installation file
  • Run as administratort5
  • Click “yes”
t6
t7
  • Chose the installation directory

t8

  • Chose directory to store data

t9

  • Specify the password for the database super user and keep it in a safe place, it will be required after installation to connect to database.

t10

  • The default port is 5432. However you can choose your custom port too. By any means if you see that the installer does not show port number 5432 it means that there must be another instance of PostgreSQL already running with port 5432. Choosing a new port here would create a new instance of the database and will run alongside the existing instance.

t12

t11
  • Now setup is ready for the installation

t13

  • Installation in progress – wait for it to complete.

t14

  • Uncheck the box for downloading tools and click on finish

t15

Connect to Database:

  • Go to pgAdmin III

t19

Now right click on database and  click on connect

t20

Use the same password which has been used for database super user in the configuration step abovet21

  • Finally the database is connected

t22

Create a Custom Database:

  • Open pgAdminIII and follow the screenshots.t25
  • Select the owner and provide a name of the databaset26
  • Keep the database definition defaultt27
  • Keep the Variable parameters also defaultt28
t29
  • Select all Role for Public Privileget30
t31
t32

Restore a Database:

  • Open pgAdminIII once again and select and existing database that you want to restoret34
  • Provide the details of the database dump file from the explorer window.t35
  • Now click on “Restore”t36
LinkedinTwitterFacebook