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