Hmm I guess so everyone thought that I was the troll who just hates X because Y reason!!<p>I did a 
sudo -u suraj createdb mydb<p>It said that role suraj didn&#x27;t exist, then I realized that postgres was using my own username, I didn&#x27;t touch a single config file! In a remarkable sense of irony, postgres is so amazing that while installation mysql needs us to give a password, postgres uses this user concept and for each database you have to create a new user so there is no one password to rule them all.<p>$ sudo -u suraj psql<p>I was just trying to do<p>$ psql<p>then it was saying that the role suraj didn&#x27;t exist<p>so I did sudo -u postgres createuser --superuser $USER<p>then it said that role suraj exists, then it said database suraj didn&#x27;t exist<p>sudo -u suraj createdb amarokdb;<p>then it created the db<p>then<p>I connected the db using the usual format