Answered by : defeated-donkey-glk49of27s40

ALTER USER user_name WITH PASSWORD 'new_password';

Source : https://stackoverflow.com/questions/12720967/postgresql-how-to-change-postgresql-user-password | Last Update : Fri, 19 Mar 21

Answered by : lennox-omondi

sudo -u postgres psql
\password postgres

Source : | Last Update : Wed, 13 Apr 22

Answered by : cautious-chimpanzee-c8uimyf46509

sudo -u user_name psql db_name
ALTER USER user_name WITH PASSWORD 'new_password';

Source : https://stackoverflow.com/questions/12720967/how-to-change-postgresql-user-password | Last Update : Fri, 04 Feb 22