[postgis-users] Error running lwpostgis.sql

[Kis János Tamás]

2006. December 21. 11.01 dátummal Mark Cave-Ayland ezt írta:
> Can you check the output of /usr/local/bin/pg_config --version? If
> it returns 8.2, then have you tried adding /usr/local/pgsql/lib to
> /etc/ld.so.conf, running ldconfig and then trying to load
> lwpostgis.sql?

# /usr/local/pgsql/bin/pg_config --version
PostgreSQL 8.2.0

# cat /etc/ld.so.conf 
/usr/X11R6/lib
/usr/local/lib
/usr/local/pgsql/lib

# ldconfig -v | egrep "(lw|pg)"
/usr/local/pgsql/lib:
        liblwgeom.so.1 -> liblwgeom.so.1.2
        libecpg.so.5 -> libecpg.so.5.2
        libecpg_compat.so.2 -> libecpg_compat.so.2.2
        libpgtypes.so.2 -> libpgtypes.so.2.2
        libpanelw.so.5 -> libpanelw.so.5.4
        libgpg-error.so.0 -> libgpg-error.so.0.1.3
        liblwres.so.1 -> liblwres.so.1.1.2

# psql -h localhost -U postgres gis < lwpostgis.sql
BEGIN
NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
ERROR:  incompatible library "/usr/local/pgsql/lib/liblwgeom.so.1.2": 
missing magic block
HINT:  Extension libraries are required to use the PG_MODULE_MAGIC 
macro.
ERROR:  current transaction is aborted, commands ignored until end of 
transaction block
...

Regards,
kjt


McAfee SCM 4.1 által ellenőrizve!