Fwd: Postgis extension bug w/ OpenBSD - Mailing list pgsql-bugs

Hello Michael,

Thanks for your answer.

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

> On Tue, Sep 17, 2013 at 4:48 PM, Marcelo Bacha <dronsz@gmail.com> wrote:
> > I have an OpenBSD 5.3 server, with PostgreSQL 9.3.0, which seems to wor=
k
> > fine. I=B4m 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=B4t think it=B4s 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 erro=
r
> on
> > psql:
> >
> >   postgres=3D# 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=B4ve cleared/uninstalled everything after upgrading Postgres to 9.3.0, an=
d
now I=B4m 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_PRELOA=
D
> > 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=B4ve been trying to solve this since a long time ago, and wi=
th
> many
> > previous versions of both Postgresql and Postgis, but I=B4m really stuc=
k
> Also, what is the output of this command? =3D> ldd
> /usr/local/pgsql/lib/rtpostgis-2.2.so
> Are you sure that rtpostgis is linked to the necessary PG libs?
>

Sure, I=B4ve tried this, here=B4s 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=B4m missing, but I can=B4t divise which o=
ne.
As you can see, there=B4s no other linked lib from pgsql/lib.

Any ideas?

Thanks a lot. Best,
Marcelo


> --
> Michael
>


--=20
Editio Princeps
http://www.editioprinceps.com