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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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