When I set the password to blank, it didn't give any warnings. Now when I try to log in with a blank password, it gives me an error "fe_sendauth: no password supplied". So now I can't log in - any ideas how I can get access to the db again?
migrated from stackoverflow.com Feb 7 at 15:51
This blogpost should answer. Full disclosure: it's my blogpost.
It really depends on how your cluster is configured...
If you have another administrator user (postgres?) you can just connect and:
Otherwise you could (temporarily) allow password-less logins in