Ident authentication failed

From: Lucky Leavell <pgsql(at)UniXpress(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Ident authentication failed
Date: 2006-01-03 03:17:07
Message-ID: Pine.LNX.4.63.0601022201220.16676@UniXpress93.unixpress.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

v8.0.3
OS: SuSE 10.0 Pro

I am new to PostgreSQL but fairly familiar with other RDBMS' such as
Ingres, Informix and MySQL.

I am attempting to switch from using MySQL to PostgreSQL with postfix. I
have created the postfix user using createuser with a password but denying
the ability to create databases or other users. However when I attempt to
login even using psql:

psql -W -U postfix

it prompts me for the password and I enter the one that user was created
with. The resulting error is:

psql: FATAL: Ident authentication failed for user 'postfix'

I know I must be missing something simple but I cannot find it in the docs
or FAQs. Please point me in the right direction.

Thank you,
Lucky

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Madison Kelly 2006-01-03 04:10:05 Re: Ident authentication failed
Previous Message Guy Rouillier 2006-01-03 03:06:01 Re: INSERT OR UPDATE