Fwd: Postgis extension bug w/ OpenBSD

Hello Michael,

Thanks for your answer.

On Thu, Sep 19, 2013 at 4:46 AM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com>wrote:

> On Tue, Sep 17, 2013 at 4:48 PM, Marcelo Bacha <dronsz(at)gmail(dot)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