Hello Michael, Thanks for your answer.
On Thu, Sep 19, 2013 at 4:46 AM, Michael Paquier <michael.paqu...@gmail.com>wrote: > On Tue, Sep 17, 2013 at 4:48 PM, Marcelo Bacha <dro...@gmail.com> wrote: > > I have an OpenBSD 5.3 server, with PostgreSQL 9.3.0, which seems to work > > fine. I´m trying to install on it, which always worked fine. > Postgres is working fine as you mention, and only PostGIS development > failed. Based on the information above which looks to be a library > linking problem for your PostGIS installation, this problem is not > related to PG. > To be honest, I don´t think it´s a Postgres problem, but maybe somebody by here would be able to help me. > > When I try to install the extension for Postgis 2.1.0, I get this error > 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 > You mention that you are trying to install postgis 2.1, but > rtpostgis-2.2.so is part of the PostGIS 2.2 bundle (version currently > in development). So which one are you trying to install? > Sorry, I just cut&pasted the previous email I sent to the postgis list, and by then I was trying with the devel bundle. I get the very same behaviour, with 2.0, 2.1 (currently stable) or 2.2. I´ve cleared/uninstalled everything after upgrading Postgres to 9.3.0, and now I´m using Postgis 2.1. > > > > > 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 > > > > When I try to preload the rtpostgis shared object setting the LD_PRELOAD > > environment variable, I get this info 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) > > (...) > > > > In fact, I´ve been trying to solve this since a long time ago, and with > many > > previous versions of both Postgresql and Postgis, but I´m really stuck > Also, what is the output of this command? => ldd > /usr/local/pgsql/lib/rtpostgis-2.2.so > Are you sure that rtpostgis is linked to the necessary PG libs? > Sure, I´ve tried this, here´s the output: # ldd /usr/local/pgsql/lib/rtpostgis-2.1.so rtpostgis-2.1.so: Start End Type Open Ref GrpRef Name 06460000 26485000 dlib 1 0 0 /usr/local/pgsql/lib/ rtpostgis-2.1.so 07ae1000 27d8a000 rlib 0 1 0 /usr/local/lib/libgdal.so.18.1 0f27b000 2f285000 rlib 0 2 0 /usr/local/lib/libgeos_c.so.9.2 0717a000 27184000 rlib 0 1 0 /usr/local/lib/libproj.so.7.0 06401000 26405000 rlib 0 1 0 /usr/local/lib/libjson.so.1.1 04171000 24198000 rlib 0 2 0 /usr/local/lib/libxml2.so.14.0 0c746000 2c74d000 rlib 0 5 0 /usr/lib/libz.so.4.1 0783c000 2791c000 rlib 0 5 0 /usr/local/lib/libiconv.so.6.0 0c04f000 2c058000 rlib 0 9 0 /usr/lib/libm.so.7.1 02fb1000 22ff4000 rlib 0 2 0 /usr/local/lib/libgeos.so 012fa000 21308000 rlib 0 1 0 /usr/lib/libsqlite3.so.21.0 0603b000 26040000 rlib 0 1 0 /usr/lib/libexpat.so.10.0 071ae000 271bd000 rlib 0 1 0 /usr/local/lib/libjasper.so.2.1 04278000 2427c000 rlib 0 1 0 /usr/local/lib/libgif.so.5.4 0894b000 28951000 rlib 0 1 0 /usr/local/lib/libjpeg.so.64.0 035b6000 235bd000 rlib 0 1 0 /usr/local/lib/libpng.so.15.14 0cba6000 2cbae000 rlib 0 1 0 /usr/local/lib/libpq.so.5.6 0856a000 28576000 rlib 0 1 0 /usr/local/lib/libcurl.so.23.0 04989000 249b5000 rlib 0 2 0 /usr/local/lib/libidn.so.17.0 03a50000 23a54000 rlib 0 3 0 /usr/local/lib/libintl.so.6.0 087de000 287eb000 rlib 0 3 0 /usr/lib/libssl.so.19.0 0cea6000 2cee5000 rlib 0 3 0 /usr/lib/libcrypto.so.22.0 0955d000 2958b000 rlib 0 3 0 /usr/lib/libstdc++.so.55.0 For sure there must be some lib I´m missing, but I can´t divise which one. As you can see, there´s no other linked lib from pgsql/lib. Any ideas? Thanks a lot. Best, Marcelo > -- > Michael > -- Editio Princeps http://www.editioprinceps.com