phpPgAdmin Login Failed

If you are unable to login to phpPgAdmin using your Cpanel username and password and getting a “Login failed” message do the following :
SSH to your server as root and open /var/lib/pgsql/data/pg_hba.conf
Search for
# “local” is for Unix domain socket connections only
local   all         all                               ident sameuser
Change it to
# “local” is for Unix domain socket connections only
local   all         all                               trust
If that doesn’t work or if it is already set to “trust”(uncommeted),
then run the following command to update phppgadmin :
# /usr/local/cpanel/bin/updatephppgadmin –force
Hope it helps…

About Sarath

A Techie from Kochi, India with 8+ years of experience in Linux and Windows server administration. I learn new things almost everyday and I enjoy the fun of learning and sharing my knowledge.