Skip site navigation (1) Skip section navigation (2)

Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>, "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls
Date: 2004-03-19 15:12:11
Message-ID: 24213.1079709131@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> writes:
> El Vie 19 Mar 2004 09:39, Kumar escribi:
>> My pg_hba.conf file looks like below
>> 
>> # TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
>> 
>> local   all         all                                             trust
>> host all     all  192.168.2.0   255.255.255.0     trust
>> 
>> I couldnt understand why. Please shed some light

> This is not the default configuration, so I suspect that you changed it.

... and forgot to SIGHUP the postmaster after changing it, so the
original IDENT-based selection is still active.  Do "pg_ctl reload"
to get the postmaster to notice changes in its config files.

			regards, tom lane

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2004-03-19 15:13:56
Subject: Re: triggers on commit
Previous:From: Tom LaneDate: 2004-03-19 15:10:05
Subject: Re: inverse of "day of year"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group