Symptoms
After input username and password, I got looping redirect to PPA.
/var/log/poa.debug.log
contain the following message:
[DBS::checkSQLError] Diagnostic info about SQL error: sqlreturn=0 state=08001, nativeCode=101, description=[unixODBC]Could not connect to the server; Connection refused [<IP_ADDRESS>:5432]
Permission on '/var/lib/pgsql/9.1/data/pg_hba.conf
' set as following:
~]# ls -la /var/lib/pgsql/9.0/data/pg_hba.conf
-rw------- 1 root root 4018 Jul 4 2013 /var/lib/pgsql/9.1/data/pg_hba.conf
Cause
Invalid permission on 'pg_hba.conf
'
Resolution
# chown postgres.postgres /var/lib/pgsql/9.1/data/pg_hba.conf