Change all authentication methods to trust .
2. Change Linux Password for postgres user.
3. Restart Server.
4. Login with psql -h localhost -U postgres and use the just set Unix password.
5. If it works you should re-set the pg_hba. conf file to values with md5 or ident methods and restart.
'password authentication failed for user "postgres"' - Stack Overflow stackoverflow.com > questions > password-authentication-failed-for-user-p...
You're getting this error because you're failing client authentication. Based on the error message, you probably have the default postgres configuration, which sets client authentication method to "IDENT" for all PostgreSQL connections.
psql: FATAL: Ident authentication failed for user "postgres"
stackoverflow.com > questions > psql-fatal-ident-authentication-failed-for-...
could not connect to Server: Connection refused If pgAdmin displays this message, there are two possible reasons for this: the database server isn't running - simply start it. the server isn't configured to accept TCP/IP requests on the address shown.
Connection Error — pgAdmin 4 5.2 documentation
www.pgadmin.org > docs > pgadmin4 > development > connect_error
The first question many ask is, “What is the default password for the user postgres?” The answer is easy… there isn't a default password. The default authentication mode for PostgreSQL is set to ident.
What is the Default Password for PostgreSQL? | Liquid Web
www.liquidweb.com > what-is-the-default-password-for-postgresql