Re: BUG #14333: Remote connections for members of role in pg_hba.conf

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

In response to

Browse pgsql-bugs by date

  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