Change password
https://stackoverflow.com/questions/12720967/how-to-change-postgresql-user-password
sudo -u user_name psql db_name
ALTER USER user_name WITH PASSWORD 'new_password';
->
sudo -u postgres psql
\password postgres
->
sudo service postgresql restart