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