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.
Click on Download the installer from EnterpriseDB for all supported versions
Chose the correct version you are looking for (here I have considered postgresql-9.3.4-3-windows-x64)
Right click on installation file
Run as administrator
Chose the installation directory
Chose directory to store data
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.
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.
Now setup is ready for the installation
Installation in progress – wait for it to complete.
Un check the box for downloading tools and click on finish
Connect to Database:
Go to pgAdmin III
Now right click on database and click on connect
Use the same password which has been used for database super user in the configuration step above
Finally the database is connected
Create a Custom Database:
Open pgAdminIII and follow the screenshots.
Select the owner and provide a name of the database
Keep the database definition default
Keep the Variable parameters also default
Select all Role for Public Privilege
Restore a Database:
Open pgAdminIII once again and select and existing database that you want to restore
Provide the details of the database dump file from the explorer window.