In any PostgreSQL Query editor just type this ALTER USER postgres WITH PASSWORD 'new_password';$ sudo -u postgres psql Then type # ALTER USER my_user_name with password 'my_secure_password';# sudo -u postgres psql could not change directory to "/root" psql (9.1.11) Type "help" for help. postgres=# \password Enter new password: Enter it again: postgres=# \q 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.In command prompt: > psql -U postgres(postgres is my username) > <Type in your current password> > \password postgrespsql -U postgressudo sed -ibak 's/^\([^#]*\)md5/\1trust/g' /opt/bitnami/postgresql/conf/pg_hba.conf sudo -u postgres pg_ctl reload pg_ctl -D "C:\Program Files\PostgreSQL\12\data" restart Langage de code : JavaScript ( javascript ) psql -U postgres