Re: BUG #4884: Misleading error message

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "William Chu" <wchu(at)facorelogic(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4884: Misleading error message
Date: 2009-06-25 23:26:33
Message-ID: 15294.1245972393@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"William Chu" <wchu(at)facorelogic(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Chu, William 2009-06-25 23:28:30 Re: BUG #4884: Misleading error message
Previous Message Tom Lane 2009-06-25 23:16:38 Re: BUG #4879: bgwriter fails to fsync the file in recovery mode