BUG #4884: Misleading error message

"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

Tom,

What's odd is after the DBA added the proper IP address entries to the
pg_hba.conf I was able to connect properly.

Regards,
Wil

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, June 25, 2009 4:27 PM
To: Chu, William
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4884: Misleading error message

"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
******************************************************************************************
This message may contain confidential or proprietary information intended only for the use of the
addressee(s) named above or may contain information that is legally privileged. If you are
not the intended addressee, or the person responsible for delivering it to the intended addressee,
you are hereby notified that reading, disseminating, distributing or copying this message is strictly
prohibited. If you have received this message by mistake, please immediately notify us by
replying to the message and delete the original message and any copies immediately thereafter.

Thank you.
******************************************************************************************
FACLD

"Chu, William" <wchu@FACorelogic.com> writes:

What's odd is after the DBA added the proper IP address entries to the
pg_hba.conf I was able to connect properly.

Well, something else must have happened in there...

regards, tom lane