Marcelo, Those missing symbols are all from PostgreSQL. You'll want to make sure the PostgreSQL libs and dev files are provided.
-bborie On Mon, Jul 1, 2013 at 1:17 PM, Marcelo Bacha <[email protected]> wrote: > Hi, > > This is my first posting, I´m new to Postgis. I´ve seen similar problems > related in lists all around, but this one, I couldn´t manage to solve. > > I have an OpenBSD 5.3 server, with PostgreSQL 9.2.4 on it, which always > worked fine. I have to transfer some geospatial databases from a Windows > server, so I downloaded Postgis from the source (I needed the latest > versions), configured, compiled & installed it. > Everything seems to be fine, but when I try to create the postgis extension > (with raster support) on psql: > > postgres=# CREATE EXTENSION postgis; > ERROR: could not load library "/usr/local/pgsql/lib/rtpostgis-2.2.so": > dlopen (/usr/local/pgsql/lib/rtpostgis-2.2.so) failed: Cannot load specified > object > > The paths seems all to be OK: > > # ls -l /usr/local/pgsql/lib/*post* > -rwxr-xr-x 1 root wheel 1276039 Jul 1 16:50 > /usr/local/pgsql/lib/postgis-2.2.so > -rwxr-xr-x 1 root wheel 1208861 Jul 1 16:50 > /usr/local/pgsql/lib/rtpostgis-2.2.so > > (I know it´s the development, and not the stable release, but the results > are the same with all other releases.) > > When I try to preload the rtpostgis shared object setting the LD_PRELOAD > environment variable, I get this on psql: > > $ psql > psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol > 'CurrentMemoryContext' > psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol > 'SPI_tuptable' > psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol 'SPI_result' > psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol > 'InterruptPending' > psql:/usr/local/pgsql/lib/rtpostgis-2.2.so: undefined symbol > 'SPI_processed' > psql (9.2.4) > > Didn´t find any further useful info setting LD_DEBUG (I may list the output > if necessary, anyway). > > Any hint on how to solve this? I´m running out of ideas. > > Thanks in advance, > Marcelo > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
