Phppgadmin gives login failed

From CPanelDirect
Jump to: navigation, search

When phppgadmin gives login failed the likely cause is pg_hba.conf needs a configuration change.

Check the file /var/lib/pgsql/data/pg_hba.conf for the following two lines:

local   all         all                                              md5
host    all         all         127.0.0.1          255.255.255.255   md5

If they are not in, add them in then restart postgresql with /scripts/restartsrv_postgres