[postgis-users] Failing: psql -d [yourdatabase] -f lwpostgis.sql

[strk at refractions.net]

On Fri, Dec 29, 2006 at 09:45:38PM -0600, Adam wrote:
> I did createlang, here is my error:
> 
> [wohldad at localhost postgis-1.1.6]$ 
> /usr/local/src/database/postgresql-8.1.3/src/bin/psql/psql -d gpsrd_v2 -f 
> lwpostgis.sql
> BEGIN
> psql:lwpostgis.sql:39: NOTICE:  type "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:lwpostgis.sql:39: ERROR:  could not load library 
> "/usr/local/pgsql/lib/liblwgeom.so.1.1": libgeos_c.so.1: cannot open shared 
> object file: No such file or directory
> psql:lwpostgis.sql:44: ERROR:  current transaction is aborted, commands 
> ignored until end of transaction block
> psql:lwpostgis.sql:52: ERROR:  current transaction is aborted, commands 
> ignored until end of transaction block
> 
> 
> What I had to do to fix this is to add:
> 
>  /usr/local/pgsql/lib
>  /usr/local/lib
> 
> to "/etc/ld.so.conf" and run "ldconfig".

And libgeos_c.so.1 is in one of the above directories ?
What does 'ldd /usr/local/pgsql/lib/liblwgeom.so.1.1' tell you ?

--strk;