Answered by : shahul
In command prompt:
> psql -U postgres(postgres is my username)
> <Type in your current password>
> \password postgres
Source : https://stackoverflow.com/a/69617712/15187131 | Last Update : Thu, 29 Sep 22
Answered by : tanishq-vyas
$ sudo -u postgres psql
Then type
# ALTER USER my_user_name with password 'my_secure_password';
Source : | Last Update : Mon, 07 Mar 22
Answered by : smiling-snake-awblx90irq5z
# 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
Source : https://stackoverflow.com/questions/10845998/i-forgot-the-password-i-entered-during-postgres-installation | Last Update : Sun, 09 May 21
Answered by : david-diamant
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 : | Last Update : Tue, 02 Mar 21
Answered by : david-bassey
psql -U postgres
Source : https://stackoverflow.com/questions/45953717/psql-fatal-password-authentication-failed-for-user-error-while-trying-to-acces | Last Update : Tue, 10 May 22
Answered by : itchy-ibis-rl8qnf5hwsec
sudo sed -ibak 's/^\([^#]*\)md5/\1trust/g' /opt/bitnami/postgresql/conf/pg_hba.conf
sudo -u postgres pg_ctl reload
Source : https://docs.bitnami.com/aws/infrastructure/postgresql/administration/change-reset-password/ | Last Update : Thu, 21 Jan 21
Answered by : enthusiastic-eel-5q048owss4bx
pg_ctl -D "C:\Program Files\PostgreSQL\12\data" restart
Langage de code : JavaScript ( javascript )
Source : https://www.postgresqltutorial.com/postgresql-reset-password/ | Last Update : Thu, 18 Nov 21