Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SHELL

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.
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #reset #postgres #password #windows
ADD COMMENT
Topic
Name
9+1 =