Log in
updated 11:29 AM UTC, May 4, 2016

How to Install Postgresql on Ubuntu 12.10

  • Written by Madhu V Rao
  • Published in Database

Postgresql is one of the most advanced open source database. It is known for its Data consistency and integrity. Its fully ACID (Atomicity , Consistency , Isolation, Durability) compliant. Enough of praising Postgresql, let's get back to installation procedure now :)

Ubuntu12.10 cache currently provides postgresql 9.1 version.  you can check the versions available in the Ubuntu cache by typing in the command:

apt-cache search postgresql-9*

Run following command on your terminal:

sudo apt-get install postgresql-9.1

if your system is not upto date , the installation might fail.

No need to worry, just update your Ubuntu packages with command:

sudo apt-get update

Once the postgresql is installed you can login to sql interface by typing in command:

sudo -u postgres psql

once logged in - set a password for Postgres role

type in \password

and enter your new password , enter \q to exit from the sql interface.

If you are managing the Postgresql from a different workstation , you have to enable remote access.

Please find it in the article: How to connect remotely to Postgresql database 9.1

 


Powered by Bullraider.com
Follow Us on Twitter
Find Us on Facebook
Follow Us on Google
Follow Us on Pinterest