[gregwhitworth]

I want to log into PSQL as the admin, much like you would with Mysql where you log in with mysql -u root -p.

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

[AdaHacker]

Check the documentation. The option is -U username - that's a capital "U". Options are case-sensitive. There is no lower-case -u option, which could explain your errors.

This post has been edited by AdaHacker: 02 November 2012 - 06:40 PM