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.
Edit pg_hba.conf, and write
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.
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
In response to
pgsql-sql by date
|Next:||From: Ruben Gouveia||Date: 2008-09-08 21:40:41|
|Subject: PL/pgSQL function syntax question?|
|Previous:||From: Tom Lane||Date: 2008-09-08 12:54:04|
|Subject: Re: problem with pg_stat_activity view |