Install Postgres & PgAdmin3 in UBUNTU

INSTALLATION

----------------------------------------------------------------------------------------------------------------------
STEP 1 : Before we install postgres,  perform a quick update of the apt-get repository :

apt-get update

(Type these commands in terminal)

STEP 2 : Once apt-get has updated go ahead and download Postgres :

sudo apt-get install postgresql postgresql-contrib


STEP 3 : Install pgadmin3 from UBUNTU Software Center
           

YOU ARE READY TO BEGIN....!!!

 ----------------------------------------------------------------------------------------------------------------------

USAGE :

  
STEP 4 : Open Terminal
  
 sudo su postgres

Enter your pc password

createdb database-name

psql database-name

create user kiran with password  'kiran';

(Add your own username & password in place of kiran)
 

STEP 5 : Open Another Terminal

pgadmin3 

 STEP 6 : Click Add a Connection to server(First Button in GUI)

  Name      : database-name
  Host        : localhost
  Port         : 5432
 Maintdb   : postgres
 username : kiran
 password : kiran
   
   YOU ARE DONE......!!!