postgres: alter postgres password

# psql -U postgres
postgres> ALTER USER postgres with password 'my-super-password';