Re: psql: FATAL: Ident authentication failed for user "postgres" - Mailing list pgsql-sql

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