[postgis-users] problem loading lwpostgis.sql - libgeos

Ronald Woita Ronald.Woita at rostock.de
Fri Apr 18 03:09:49 PDT 2008


Hi list,

I have a problem loading the lwpostgis.sql into a database.
(plpgsql is already loaded)

this is the message from Postgres-Serverlog :

-->
NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
ERROR:  could not load library "/usr/local/pgsql/lib/liblwgeom.so":
/usr/local/lib/libgeos-3.0.0.so: undefined symbol:
_ZTVN10__cxxabiv120__si_class_type_infoE
STATEMENT:  CREATE OR REPLACE FUNCTION histogram2d_in(cstring)
		RETURNS histogram2d
		AS '/usr/local/pgsql/lib/liblwgeom', 'lwhistogram2d_in'
		LANGUAGE 'C' IMMUTABLE STRICT;
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
<--
(for complete log see attachement)

ldd liblwgeom.so provides this :
	linux-gate.so.1 =>  (0xffffe000)
	libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 (0xb7e7a000)
	libproj.so.0 => /usr/local/lib/libproj.so.0 (0xb7e48000)
	libc.so.6 => /lib/libc.so.6 (0xb7d27000)
	libgeos-3.0.0.so => /usr/local/lib/libgeos-3.0.0.so
(0xb7aac000)
	libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7aa0000)
	libm.so.6 => /lib/libm.so.6 (0xb7a7b000)
	/lib/ld-linux.so.2 (0x80000000)

I checked the libraries and did'nt found any errors. 
the necessary path variables /usr/local/pgsql/lib and /usr/local/lib
are correctly listed  in /etc/ld.so.conf

any hints welcome !

The System Enviroment is 
PostgeSQL 8.3.1
PostGIS 1.3.3
GEOS-3.0.0
on SLES 10SP1


best regards
Ronald




More information about the postgis-users mailing list