error when trying to do
psql -U postgres template1
psql: FATAL: Ident authentication failed for user “postgres”
Explanation:- access permission in /var/lib/pgsql/data/pg_hba.conf
this problem was solved by editing ” /var/lib/pgsql/data/pg_hba.conf” file
This file decide how the host are allowed to connect and which databases they can use.
Modify the entry as this
local all all trust
host all all 127.0.0.1/32 trust