I am having problems with authentication. Whatever I try I always get
this error.
psql: FATAL 1: Password authentication failed for user <username>
I am trying to use MD5. I tried with system users and with postgres user
and with user added with ADD USER <username> WITH ENCRYPTION PASSWORD
'thepassword'
I am on a RedHat linux 7.3 with postgresql 7.2.1
Any help appreciated.