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

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

From: "Dan Joo" <djoo(at)agraquest(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: psql: FATAL: Ident authentication failed for user "postgres"
Date: 2008-05-20 00:18:49
Message-ID: 4676DF8318F32F4AB7E98BCD9BC90628E86168@agq-ex01.agraquest.int (view raw or flat)
Thread:
Lists: pgsql-general
Hi everyone,

 

I am having problems logging into psql as a non-'postgres' user.

  

/home/djoo[5:38pm]$ %psql kermit -U postgres

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

 

Below is a portion of the pg_hba.conf file, which I believe is
configured so that a password is not required. 

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

 

# "local" is for Unix domain socket connections only

local   all         all                               trust

# IPv4 local connections:

host    all         all         127.0.0.1/32          trust

# IPv6 local connections:

host    all         all         ::1/128               trust

 

Any suggestions would be greatly appreciated!

 

Dan

 

Responses

pgsql-general by date

Next:From: Nathan ThatcherDate: 2008-05-20 00:23:17
Subject: Create database without entering password at command line
Previous:From: Sam MasonDate: 2008-05-20 00:04:30
Subject: Re: Join three fields into one on same table

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