In Postgresql How to solve: psql: FATAL: database “root” does not exist Error

By Angsuman Chakraborty, Gaea News Network
Thursday, October 16, 2008

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?

YOUR VIEW POINT
NAME : (REQUIRED)
MAIL : (REQUIRED)
will not be displayed
WEBSITE : (OPTIONAL)
YOUR
COMMENT :