Postgresql Windows, is there a default password? [closed]
Try this:
Open PgAdmin -> Files -> Open pgpass.confYou 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.
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