From: Chris [mailto:dmagick@xxxxxxxxx]
Sent: Mon 5/19/2008 8:34 PM
To: Dan Joo; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] 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@xxxxxxxxx]
> Sent: Monday, May 19, 2008 6:22 PM
> To: Dan Joo
> Cc: pgsql-general@xxxxxxxxxxxxxx
> 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/
