How do I fix the "Authentication Failed" error when connecting to PostgreSQL?

psql: FATAL:  password authentication failed for user "your_username"

An Authentication Failed error occurs when:

  • You connect to the wrong database cluster.
  • You use the wrong username or password.

If you are getting this error, check the cluster and username/password combination you’re using. To better review changes, we recommend the flags format to modify the connection string. For more on the flags format, see How To Connect to PostgreSQL.

Verify the connection string, ensure correct port usage, and add your local machine to the database cluster’s trusted sources.
Add your machine to the database cluster’s list of trusted sources in the firewall settings.
Verify the format and values in the connection string for typos or formatting errors.