Skip site navigation (1) Skip section navigation (2)

Re: psql: FATAL: Ident authentication failed for user"postgres"

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: VG <vikasraigupta(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: psql: FATAL: Ident authentication failed for user"postgres"
Date: 2008-09-08 12:59:46
Message-ID: 1220878786.2711.24.camel@laptop.gunduz.org (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-sql by date

Next:From: Ruben GouveiaDate: 2008-09-08 21:40:41
Subject: PL/pgSQL function syntax question?
Previous:From: Tom LaneDate: 2008-09-08 12:54:04
Subject: Re: problem with pg_stat_activity view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group