postgres

psql -U postgres

#permiso para crear BDs:
ALTER USER cpanel_user_bd createdb;

#cambio de clave:
ALTER USER cpanel_user_bd WITH PASSWORD 'newpass';

Edit:
/var/lib/pgsql/data/pg_hba.conf

Add:
host all cpanel_user_bd   ::1/128      md5