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