How to install PostgreSql in Ubuntu Server 12.10 (Quantal)

  1. #sudo apt-get install python-software-properties 
  2. #sudo apt-get install postgresql
  3. #sudo apt-get install postgresql-9.1 libpq-dev
  4. #psql -V 
  • #sudo passwd postgres
  • #su postgres
  • #vi¬†/etc/postgresql/9.1/main/pg_hba.conf¬†
  • host ¬† ¬†all ¬† ¬† ¬† ¬† ¬† ¬† all ¬† ¬† ¬† ¬† ¬† ¬† 127.0.0.1/32 ¬† ¬† ¬† ¬† ¬† ¬†trust ¬†#md5
  • #/etc/init.d/postgresql restart