SyntaxFix

[windows] Postgresql Windows, is there a default password?

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

Examples related to windows

• "Permission Denied" trying to run Python on Windows 10 • A fatal error occurred while creating a TLS client credential. The internal error state is 10013 • How to install OpenJDK 11 on Windows? • I can't install pyaudio on Windows? How to solve "error: Microsoft Visual C++ 14.0 is required."? • git clone: Authentication failed for <URL> • How to avoid the "Windows Defender SmartScreen prevented an unrecognized app from starting warning" • XCOPY: Overwrite all without prompt in BATCH • Laravel 5 show ErrorException file_put_contents failed to open stream: No such file or directory • how to open Jupyter notebook in chrome on windows • Tensorflow import error: No module named 'tensorflow'

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside