psycopg2 authentication fails for auth mode "ident"

[stevenvergenz]

For whatever reason, psycopg2 fails to authenticate the postgresql user if the authentication mode is set to "ident" in the postgresql server config. You get the error:

psycopg2.OperationalError: FATAL: Ident authentication failed for user <db_user>

This is a problem because ident is the default security mode on Redhat-based distros. In order for it to work, the psql auth mode must be set to either md5 or trust in /var/lib/pgsql/data/pg_hba.conf.

[ljwolford]

Not meant for Redhat-based distros, lists Ubuntu environment at top of instructions. If you wanted to write up an install script in the wiki for Redhat distros, that would work and be great, thanks!