November 17, 2015

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 directoryt8
  • Chose directory to store datat9
  • 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 installationt13
  • Installation in progress – wait for it to complete.t14
  • Un check the box for downloading tools and click on finisht15

Connect to Database:

  • Go to pgAdmin IIIt19
  • Now right click on database and  click on connectt20
  • Use the same password which has been used for database super user in the configuration step abovet21
  • Finally the database is connectedt22

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

Leave a Reply

Your email address will not be published. Required fields are marked *