Re: BUG #9518: temporary login failure - "missing pg_hba entry"

On Sat, Mar 29, 2014 at 8:36 AM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>wrote:

This particular host is listed in pg_hba.conf by host name rather than by
> IP address. Is it possible this error is due to an intermittent DNS
> failure?
>

Not sure, if this issue still persists -

We had the similar situation in the past -

If the host is listed in the pg_hba.conf file - the reloading of the
configuration was successful ?

Any unnecessary blank spaces or the entries which are in-correct format
will not let the pg_hba.conf reload be successful.

In our case - some other host's entry was troubling us, it worked fine,
when we commented it out.

OR

May be you need to re-check the DNS configuration and see if you are able
to ping the DB server host ( using DNS name and IP address both ).

May be DB server is not recognizing the DNS hostname ( check /etc/hosts ).

Regards,

Venkata Balaji N
Fujitsu Australia