Re: BUG #4884: Misleading error message - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4884: Misleading error message
Date
Msg-id 15294.1245972393@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4884: Misleading error message  ("William Chu" <wchu@facorelogic.com>)
Responses Re: BUG #4884: Misleading error message
List pgsql-bugs
"William Chu" <wchu@facorelogic.com> writes:
> The following error message occurs when the IP address is not present in the
> pg_hba.conf.  The error message is misleading and should actually say
> something to the effect, "Connection refused due to lack of access
> permission".

> java.io.IOException: An SQL exception occurred: ERROR: could not load
> library "/usr/local/pgsql/lib/libpostgis.so.0.9": libgeos.so.2: cannot open
> shared object file: No such file or directory

Huh?  That error message can't possibly have anything to do with the
contents of pg_hba.conf.  What it looks like to me is a broken PostGIS
installation, ie, libpostgis present but libgeos missing.  If you're
seeing it at connect time, perhaps you have postgis set up as a
preloaded library?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: BUG #4879: bgwriter fails to fsync the file in recovery mode
Next
From: Tom Lane
Date:
Subject: Re: BUG #4884: Misleading error message