erro no postgis -> could not load library "/opt/pgsql/lib/postgis-1.5.so"

Fri, 17 Sep 2010 22:28:04 -0700 

instalei primeiro o postgresql8.4 e depois o postgis1.5, e todas lib ficou
em /opt/pgsql/lib

$ ls /opt/pgsql/lib/postgis*
/opt/pgsql/lib/postgis-1.5.so

esta lá mas se tento rodar um :

pg...@micro$ /opt/pgsql/bin/psql -f share/contrib/postgis-1.5/postgis.sql
--port=5800 --host=localhost -d geomapas


WARNING:  nonstandard use of \\ in a string literal at character 263
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
FATAL:  database "pgsql" does not exist
FATAL:  database "maas" does not exist
*ERROR:  could not load library "/opt/pgsql/lib/postgis-1.5.so":
/opt/pgsql/lib/postgis-1.5.so: undefined symbol: GEOSHausdorffDistance*
STATEMENT:  CREATE OR REPLACE FUNCTION st_spheroid_in(cstring)
                RETURNS spheroid
                AS '$libdir/postgis-1.5','ellipsoid_in'
                LANGUAGE 'C' IMMUTABLE STRICT;
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
STATEMENT:  CREATE OR REPLACE FUNCTION st_spheroid_out(spheroid)
                RETURNS cstring


tenho que fazer

ldconfig /opt/pgsql/lib

pra rodar ok?

como faço que lib que estão ali seja usadas perfeitamente?

isso esta sobre um debian lenny.

Responder a