https://help.ubuntu.com/community/PostgreSQL
1. Installing server locally
$sudo apt-get install postgresql postgresql-contrib
2. Administration using GUI tool pgAdmin3
$sudo apt-get install pgadmin3
3. Basic server setup
$sudo -u postgres psql postgres
\password postgres
Give password when prompted. Then type Control+D or \q to exit the posgreSQL prompt.
4. Create database
sudo -u postgres createdb <database-name>
5.Using pgadmin3 GUI tool
$pgadmin3
Rating: