Answers for "remove password from user postgres"

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

forgot postgres password

psql -U postgres
Posted by: Guest on May-03-2022

Code answers related to "remove password from user postgres"

Browse Popular Code Answers by Language