PostgreSQL on Windows: is there a default password? [closed]

by

Try this:

Open PgAdmin -> Files -> Open pgpass.conf

You would get the path of pgpass.conf at the bottom of the window.
Go to that location and open this file, you can find your password there.

Reference

If the above does not work, you may consider trying this:

  1. Edit pg_hba.conf to allow trust authorization temporarily
  2. Reload the config file (pg_ctl reload)
  3. Connect and issue ALTER ROLE / PASSWORD to set the new password
  4. Edit pg_hba.conf again and restore the previous settings
  5. Reload the config file again

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)