psql: FATAL: Ident authentication failed for user "postgres"
postgresql
Solution
Did you set the proper settings in pg_hba.conf?
See https://ubuntu.com/server/docs/databases-postgresql how to do it.
Problem
I have installed PostgreSQL and pgAdminIII on my Ubuntu Karmic box. I am able to use pgAdminIII successfully (i.e. connect/log on), however when I try to login to the server using the same username/pwd on the command line (using psql), I get the error: ``` psql: FATAL: Ident authentication failed for user "postgres" ``` Does anyone now how to resolve this issue?