On Sat, Mar 29, 2014 at 8:36 AM, Mike Blackwell <mike.blackwell@rrd.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