Learning is an Art

To install latest version of postgresql we first we need to add pgdg repository to list of repositories open terminal and fire following commands, you need to be root.

Once repository is installed properly use yum to install postgresql as shown below

You can do above in a single line choice is yours.

Initialize the database

Start the database server

Voila your database server is setup and ready to use.

Few days back I was trying to create database in a batch job using createdb.exe and I encountered this problem createdb.exe prompts for password and there is no way of passing password from command line as an argument.
I tried to find out how to do this but in vein there is no way you can pass password as an command line argument; than after looking around for sometime and googling I found two ways of doing it

• Setting up PGPASSWORD environment variable : This method is not preferable as it’s insecure more for further details read this

• Setting up password in pgpass.conf : The file is to be located
  %APPDATA%\postgresql\pgpass.conf

File has the following format

Each of the first four fields may be a literal value, or *, which matches anything.

For further details the postgres documentation