forgot postgres password linux code example
Example 1: 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
Example 2: reset password postgres ubuntu
\password sde