Postgresql command line interface psql presents a stumbling block to any mysql users. Try running psql on command line and you will get a nice and unfriendly error message: FATAL:  database "root" does not exist

Most MySQL users face this problem initially with Postgresql because Postgresql works differently.

Postgresql allows each user to create one or more databases. The default postgresql user is normally postgresql. You will have to su to postgres account before you can run psql and then it will work fine. Simple, isn't it?