Postgresql changing db pass

How to change the DB password for local postgresql database ‘engine’

    1. make a backup
  1. read PASSWD
  2. /etc/pki/ovirt-engine/ $PASSWD
  3. unset PASSWD
    1. copy the encrypted password and uptate the file /etc/sysconfig/ovirt-engine with the encrypted password
  4. update the clear-text password in the file /etc/ovirt-engine/.pgpass
  5. su - postgres
  6. postgres=# alter user engine with password ‘NEW_CLEAR_TEXT_PASS’;
  7. postgres=# alter user postgres with password ‘NEW_CLEAR_TEXT_PASS’;
  8. service ovirt-engine restart

Everything should work as before.