CODE EXAMPLE FOR SQL

set password for postgres user ubuntu

sudo -u postgres psql
ALTER USER <myuser> WITH PASSWORD 'mypassword';