On Mon, 2008-09-08 at 15:39 +0530, VG wrote: > hba.conf group and owner were postgres then i changed it to root. > > when i type psql -U postgres command ( as root user) I get: > > psql: FATAL: Ident authentication failed for user "postgres"
First, revert the owner/group change.
Then, su - postgres and then run psql.
Or:
Edit pg_hba.conf, and write
trust
instead of "ident sameuser" -- then reload PostgreSQL
As root: service postgresql reload
or as postgres user: pg_ctl reload
Ownership of pg_hba.conf has nothing to do with the authentication.
Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
signature.asc
Description: This is a digitally signed message part
