In Postgresql How to solve: psql: FATAL: database “root” does not exist Error
By Angsuman Chakraborty, Gaea News NetworkThursday, 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