Answers for "how to recover psql password"

2

reset postgres password windows

Backup the pg_hba.conf file by copying it.
Edit the pg_dba.conf, change `METHOD` to 'trust'
Restart the PostgreSQL server.
psql -U postgres.
ALTER USER postgres WITH PASSWORD 'new_password';
Restore the pg_dba.conf file.
Restart the PostgreSQL server.
Posted by: Guest on February-23-2021
0

reset postgre password

$ sudo -u postgres psql

Then type

# ALTER USER my_user_name with password 'my_secure_password';
Posted by: Guest on February-28-2022

Code answers related to "how to recover psql password"

Browse Popular Code Answers by Language