While clicking phpPgAdmin from cpanel, I got “login failed”. On checking the cpanel error log, I got the following error.
————-
Cpanel::PostgresAdmin::exec_psql(Cpanel::PostgresAdmin=HASH(0x2b3a900), ‘GRANT ALL PRIVILEGES on DATABASE “xxx_yyy” TO “xxx_yyy”;’) called at /usr/local/cpanel/Cpanel/PostgresAdmin.pm line 362I directory.
————-
I have fixed the issue by clearing the database cache files from cpanel database directory.
Steps
======
1, cd /var/cpanel/databases
2, rm -rf /var/cpanel/databases/<username>.cache
3, Rename the yaml file related to this cpanel user (/var/cpanel/databases/<username>.yaml)
vishnulinux 