Re: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file

On Wed, 31 May 2000, Ira Waxberg wrote:

> I get this error only when coming in from the local host! Remote clients,
> oddly enough, don't have this problem.
>
> Something unusual has occured to cause the driver to fail. Please report
> this exception: java.sql.SQLException: Missing or erroneous pg_hba.conf
> file, see postmaster log for details

This is being sent to the backend as it's seeing a corrupt pg_hba.conf
file.

This file could also be missing but as you include it next, it's not that.

> The pg_hba.conf file:
>
> host all 127.0.0.1 255.255.255.255 trust
> host all 203.216.99.58 255.255.255.255 trust
> host all 203.216.99.58 trust

This line is corrupt as it's missing the subnet mask. delete it, as it's a
duplicate of the preciding line.

Peter

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf