0

I tried once to change my postgres account password using ALTER USER like this ALTER USER postgres PASSWORD ''; and it accept it ,

but when i tried to log in it didnt work it always geives me the error: psql: error: FATAL: password authentication failed for user "postgres"

so how can i login again or change th password?

  • Do you have any other superusers available you can log in as? – jjanes Jan 25 '21 at 18:56
  • @jjanes No I dont have other superusers I can log in, but it is ok because I didnt need to, I used the answer in this question https://stackoverflow.com/questions/5421807/set-blank-password-for-postgresql-user and it worked. But thank you anyway. – Rania Al_saide Jan 27 '21 at 21:04

1 Answers1

-1

Try log in without using a password as suggested in this solution, I hope it helps you

Danny
  • 326
  • 3
  • 15