But I keep getting the error when running psql -l: psql: FATAL: role "root" does not exist
I have looked into this and found that psql by default looks at the current user and uses that as the user trying to run the command. But even doing something like psql -u postgres -l or psql -l -u postgres comes back with syntax errors.
I am just wanting to get root access and it seems like the only way to do this is to be the postgres user, how do I force psql to use that user?
This post has been edited by gregwhitworth: 02 November 2012 - 10:29 AM