Re: BUG #14333: Remote connections for members of role in pg_hba.conf - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14333: Remote connections for members of role in pg_hba.conf
Date
Msg-id 23442.1474509282@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14333: Remote connections for members of role in pg_hba.conf  (brodgers3@oreillyauto.com)
List pgsql-bugs
brodgers3@oreillyauto.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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #14334: vacuumdb.c build failure on openbsd
Next
From: Tony Wecker
Date:
Subject: Re: pgdg94 conflicts with RHEL 6.8