In order to change the password of a user in PostgreSQL we do the following:

ALTER ROLE username
WITH PASSWORD 'password';