| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-19 15:13:56 | Re: triggers on commit |
| Previous Message | Tom Lane | 2004-03-19 15:10:05 | Re: inverse of "day of year" |