> I have installed postgresql-serve using yum
> 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"
Most probably the default pg_hba.conf includes the following line:
local all postgres ident
Which means that you could login with the DB user "postgres" only if you
are logged in already as the system user "postgres". So "su - postgres"
before using psql should do the trick.
Please read "Chapter 21. Client Authentication"
Milen A. Radev
In response to
pgsql-sql by date
|Next:||From: Sofer, Yuval||Date: 2008-09-08 11:29:50|
|Subject: problem with pg_stat_activity view|
|Previous:||From: Filip Rembiałkowski||Date: 2008-09-08 10:22:04|
|Subject: Re: psql: FATAL: Ident authentication failed for user "postgres"|