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

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

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: psql: FATAL: Ident authentication failed for user "postgres"
Date: 2008-09-08 11:07:24
Message-ID: ga311h$js1$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-sql
VG написа:
> Hi,
> 
> I have installed postgresql-serve using yum
> hba.conf group and owner were postgres then i changed it to root.

Why?

> 
> 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"
(http://www.postgresql.org/docs/current/static/client-authentication.html)
for details.


-- 
Milen A. Radev


In response to

pgsql-sql by date

Next:From: Sofer, YuvalDate: 2008-09-08 11:29:50
Subject: problem with pg_stat_activity view
Previous:From: Filip RembiałkowskiDate: 2008-09-08 10:22:04
Subject: Re: psql: FATAL: Ident authentication failed for user "postgres"

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