Recently I resumed working on Ubuntu. While setting up the working environment, I had to setup Postgressql followed by creating a new database and stuff like that. In between I encountered certain problems and correspondingly found solutions also. Through this blog I thought things should be at one place for a newcomer.
From initial installation point of view https://help.ubuntu.com/community/PostgreSQL is a good resource. Though instead of using pgadmin3 I like to use SQuirreL SQL Client.
I had to create a new user which could be used to create a new database. Everything worked except postgres didn’t allow new user to enter into new database. I found a solution at http://www.cyberciti.biz/faq/psql-fatal-ident-authentication-failed-for-user and it worked like a charm.