How to install postgresql into ubuntu

Installation

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib

Backup

pg_dump my_postgres_db > my_postgres_db.sql

Restore

plsql my_postgres_db < my_postgres_db.sql