| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | brodgers3(at)oreillyauto(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14333: Remote connections for members of role in pg_hba.conf |
| Date: | 2016-09-22 01:54:42 |
| Message-ID: | 23442.1474509282@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
brodgers3(at)oreillyauto(dot)com writes:
> --- Error received upon attempting remote connection ---
> FATAL: no pg_hba.conf entry for host "172.XX.YY.ZZ", user "myuser", database
> "mydb", SSL off
> Expected either valid connection or password error.
This example works for me (after suitable adjustment of the IP addresses).
Only theory that comes to mind offhand is that you forgot to tell the
postmaster to reload the pg_hba.conf file after you edited it (via pg_ctl
reload, SIGHUP, etc).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Wecker | 2016-09-22 06:31:38 | Re: pgdg94 conflicts with RHEL 6.8 |
| Previous Message | Alvaro Herrera | 2016-09-21 23:25:11 | Re: BUG #14334: vacuumdb.c build failure on openbsd |