set password in postgres code example

Example 1: create password for user in postgres

ALTER USER davide WITH PASSWORD 'hu8jmn3';

Example 2: how to reset postgres password

sudo sed -ibak 's/^\([^#]*\)md5/\1trust/g' /opt/bitnami/postgresql/conf/pg_hba.conf
sudo -u postgres pg_ctl reload