Thread: Authentication problems.

Authentication problems.

From
Nadim Bitar
Date:
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.





Re: Authentication problems.

From
Nadim Bitar
Date:
I solved my problems. I was issuing the wrong command to create users
and alter the user's passwords.