Posted by Weston Ganger
Im always forgetting how to do this. Dont set the password for the linux account postgres, instead set the password for the postgres user in psql.
sudo -u postgres psql postgres # In psql prompt \password postgres # Enter your password
Now when you want to connect to psql use the following command
psql postgres -U postgres
See my other article on setting it up with the current user so your not messing around with the postgres user
Related External Links: