After reading back through your initial email, ignore the missing PostgreSQL symbols as the problem really is the loading of rtpostgis-2.2.so in PostgreSQL.
Based upon the ldd output, all the libraries that your rtpostgis-2.2.so library depends on is found. I don't believe my advice will be of much value as I haven't used *BSD in a very long time... -bborie On 07/10/2013 02:08 PM, Marcelo Bacha wrote: > Here´s the output: > > # ldd /usr/local/pgsql/lib/rtpostgis-2.2.so > /usr/local/pgsql/lib/rtpostgis-2.2.so: > Start End Type Open Ref GrpRef Name > 0ee98000 2eebd000 dlib 1 0 0 /usr/local/pgsql/lib/ > rtpostgis-2.2.so > 08a43000 28cec000 rlib 0 1 0 > /usr/local/lib/libgdal.so.18.0 > 041ef000 241f9000 rlib 0 2 0 > /usr/local/lib/libgeos_c.so.8.8 > 003f6000 20400000 rlib 0 1 0 /usr/local/lib/libproj.so.7.0 > 0e834000 2e838000 rlib 0 1 0 /usr/local/lib/libjson.so.1.1 > 0a36a000 2a391000 rlib 0 2 0 > /usr/local/lib/libxml2.so.14.0 > 06045000 2604c000 rlib 0 5 0 /usr/lib/libz.so.4.1 > 0fce8000 2fdc8000 rlib 0 5 0 > /usr/local/lib/libiconv.so.6.0 > 059df000 259e8000 rlib 0 9 0 /usr/lib/libm.so.7.1 > 064e4000 26526000 rlib 0 2 0 /usr/local/lib/libgeos.so > 0dfef000 2dffd000 rlib 0 1 0 /usr/lib/libsqlite3.so.21.0 > 07bdf000 27be4000 rlib 0 1 0 /usr/lib/libexpat.so.10.0 > 007b8000 207c7000 rlib 0 1 0 > /usr/local/lib/libjasper.so.2.1 > 0ae63000 2ae67000 rlib 0 1 0 /usr/local/lib/libgif.so.5.4 > 077d1000 277d7000 rlib 0 1 0 > /usr/local/lib/libjpeg.so.64.0 > 0978e000 29795000 rlib 0 1 0 > /usr/local/lib/libpng.so.15.14 > 09594000 2959c000 rlib 0 1 0 /usr/local/lib/libpq.so.5.5 > 00a2d000 20a39000 rlib 0 1 0 > /usr/local/lib/libcurl.so.23.0 > 05f63000 25f8f000 rlib 0 2 0 /usr/local/lib/libidn.so.17.0 > 02e03000 22e07000 rlib 0 3 0 /usr/local/lib/libintl.so.6.0 > 0ab0d000 2ab1a000 rlib 0 3 0 /usr/lib/libssl.so.19.0 > 0d71c000 2d75b000 rlib 0 3 0 /usr/lib/libcrypto.so.22.0 > 094ce000 294fc000 rlib 0 3 0 /usr/lib/libstdc++.so.55.0 > > Indeed, there´s no shared object from /usr/local/pgsql/lib, is this correct? > > Anyway, I´ve included this path at the /etc/rc.conf shlib_dirs variable, so > rc execute the proper ldconfig command, which is just OK: > > # ldconfig -r | grep pgsql > search directories: > /usr/lib:/usr/X11R6/lib:/usr/local/lib:/usr/local/pgsql/lib > 328:-lpgtypes.3.3 => /usr/local/pgsql/lib/libpgtypes.so.3.3 > 329:-lecpg.6.4 => /usr/local/pgsql/lib/libecpg.so.6.4 > 331:-lecpg_compat.3.4 => /usr/local/pgsql/lib/libecpg_compat.so.3.4 > > Marcelo > > > > > > On Wed, Jul 10, 2013 at 5:06 PM, dustymugs <[email protected]> wrote: > >> Marcelo, >> >> See if rtpostgis-2.2.so can find the PostgreSQL libs. >> >> ldd /usr/local/pgsql/lib/rtpostgis-2.2.so >> >> -bborie >> >> On 07/10/2013 12:32 PM, Marcelo Bacha wrote: >>> Thanks Bborie. >>> >>> I went back to PostgreSQL, to check the warnings from compilation. I >>> Corrected a couple of things, applied a recent patch for the configure >>> properly recognize sys/ucred.h, and so on, but nothing changed the >>> situation. >>> Here´s how it´s configured: >>> >>> ./configure --enable-depend --with-openssl --with-libxml --with-libxslt >>> --with-perl --enable-debug --disable-thread-safety >>> >>> I´m running out of ideas... >>> >>> Best, >>> Marcelo >>> >>> >>> On Mon, Jul 1, 2013 at 5:19 PM, Bborie Park <[email protected]> wrote: >>> >>>> 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 >>>> >>> >>> >>> >>> >>> >>> _______________________________________________ >>> 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 >> > > > > > > _______________________________________________ > 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
