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

Dan,

Always cc the mailing list so others can provide other suggestions where
necessary.

Dan Joo wrote:
> Thanks, Chris, but yes, I am sure that there is no such line.  (see below)
>
> [root@RH-Dev data]# cat pg_hba.conf | grep -v '^#'
>
>
>
>
>
> local   all         all                               trust
> host    all         all         127.0.0.1/32          trust
> host    all         all         ::1/128               trust
>
> Dan

Did you HUP postmaster?

The docs say you can just pg_ctl reload to do this.


> -----Original Message-----
> From: Chris [mailto:dmagick@gmail.com]
> Sent: Monday, May 19, 2008 6:22 PM
> To: Dan Joo
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] psql: FATAL: Ident authentication failed for user "postgres"
>
> Dan Joo wrote:
>> 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"*
>
> Sure there isn't a line like this:
>
> local   all         postgres                          ident sameuser
>
> uncommented?
>
> $ cat /path/to/pg_hba.conf | grep -v '^#'
>
> Normally the 'postgres' user is 'ident' only unless you remove (or
> comment out) that particular line, then restart postgres.
>


--
Postgresql & php tutorials
http://www.designmagick.com/