| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | David Hillman <david(at)kapitaltrading(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #17249: Bug in .pgpass search and/or documentation thereof, Ubuntu 13.4-4 |
| Date: | 2021-10-28 16:17:27 |
| Message-ID: | 488035.1635437847@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> Your original email demonstrates that, absent -h localhost, psql is looking
> for and finding a local socket and thus the first matching entry is a
> "local" one which does not require password entry because it is set for
> "peer". This is working as intended.
Indeed. If you don't like the results you're getting, you need to go
adjust your pg_hba.conf file. Right now, you've got it set to apply
different authentication rules for Unix-socket and localhost connections,
and you apparently don't want that.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Savita Naik | 2021-10-28 16:33:58 | Error in 'FROM' function |
| Previous Message | David G. Johnston | 2021-10-28 16:06:45 | Re: BUG #17249: Bug in .pgpass search and/or documentation thereof, Ubuntu 13.4-4 |