On Saturday 18 September 2010 02:27:42 Sorocaos . wrote:
> 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 :
>
> pgsql@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.