RHEVM database export fails with the error : ¨pg_dump: [archiver (db)] connection to database "rhevm" failed: fe_sendauth: no password supplied¨

Issue

Ran the command below to export RHEVM database :

pg_dump rhevm -U postgres -w -f /tmp/rhevmdb-$(date +%F_%T:%S).dump -F t

RHEVM database export fails with the error below :

pg_dump: [archiver (db)] connection to database "rhevm" failed: fe_sendauth: no password supplied