CODE EXAMPLE FOR SQL

reset postgre password

$ sudo -u postgres psql

Then type

# ALTER USER my_user_name with password 'my_secure_password';