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

[Chris <dmagick(at)gmail(dot)com>]

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(at)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(at)gmail(dot)com] 
> Sent: Monday, May 19, 2008 6:22 PM
> To: Dan Joo
> Cc: pgsql-general(at)postgresql(dot)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/