[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-bugs
Subject: Fwd: [BUGS] Postgis extension bug w/ OpenBSD
From: Marcelo Bacha <dronsz () gmail ! com>
Date: 2013-09-23 9:03:09
Message-ID: CAOfDtHPFpHx=zN+dQ5Art1-vrW-d0pb1qvucaiO6oXcYorL3bA () mail ! gmail ! com
[Download RAW message or body]
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 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
[Attachment #3 (text/html)]
<div dir="ltr">Hello Michael,<br><div class="gmail_quote"><div \
dir="ltr"><div><br></div><div>Thanks for your answer.</div><div \
class="gmail_extra"><div class="im"><br>On Thu, Sep 19, 2013 at 4:46 AM, Michael \
Paquier <span dir="ltr"><<a href="mailto:michael.paquier@gmail.com" \
target="_blank">michael.paquier@gmail.com</a>></span> wrote:<br>
</div><div class="gmail_quote"><div class="im"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div>On \
Tue, Sep 17, 2013 at 4:48 PM, Marcelo Bacha <<a href="mailto:dronsz@gmail.com" \
target="_blank">dronsz@gmail.com</a>> wrote:<br>
> I have an OpenBSD 5.3 server, with PostgreSQL 9.3.0, which seems to work<br>
> fine. I´m trying to install on it, which always worked fine.<br>
</div>Postgres is working fine as you mention, and only PostGIS development<br>
failed. Based on the information above which looks to be a library<br>
linking problem for your PostGIS installation, this problem is not<br>
related to PG.<br></blockquote><div><br></div></div><div>To be honest, I don´t think \
it´s a Postgres problem, but maybe somebody by here would be able to help \
me.</div><div class="im"><div> </div><blockquote class="gmail_quote" \
style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>
> When I try to install the extension for Postgis 2.1.0, I get this error on<br>
> psql:<br>
><br>
> postgres=# CREATE EXTENSION postgis;<br>
> ERROR: could not load library "/usr/local/pgsql/lib/<a \
href="http://rtpostgis-2.2.so" target="_blank">rtpostgis-2.2.so</a>":<br> > \
dlopen (/usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so" \
target="_blank">rtpostgis-2.2.so</a>) failed: Cannot load specified<br> > \
object<br> </div>You mention that you are trying to install postgis 2.1, but<br>
<a href="http://rtpostgis-2.2.so" target="_blank">rtpostgis-2.2.so</a> is part of the \
PostGIS 2.2 bundle (version currently<br> in development). So which one are you \
trying to install?<br></blockquote><div><br></div></div><div>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.</div>
<div>I´ve cleared/uninstalled everything after upgrading Postgres to 9.3.0, and now \
I´m using Postgis 2.1.</div><div><div class="h5"><div> </div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div><br>
><br>
> The paths seems all to be OK:<br>
><br>
> # ls -l /usr/local/pgsql/lib/*post*<br>
> -rwxr-xr-x 1 root wheel 1276039 Jul 1 16:50<br>
> /usr/local/pgsql/lib/<a href="http://postgis-2.2.so" \
target="_blank">postgis-2.2.so</a><br> > -rwxr-xr-x 1 root wheel 1208861 Jul \
1 16:50<br> > /usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so" \
target="_blank">rtpostgis-2.2.so</a><br> ><br>
> When I try to preload the rtpostgis shared object setting the LD_PRELOAD<br>
> environment variable, I get this info on psql:<br>
><br>
> $ psql<br>
> (...)<br>
> psql:/usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so" \
target="_blank">rtpostgis-2.2.so</a>: undefined symbol<br> > \
'CurrentMemoryContext'<br> > psql:/usr/local/pgsql/lib/<a \
href="http://rtpostgis-2.2.so" target="_blank">rtpostgis-2.2.so</a>: undefined \
symbol<br> > 'SPI_tuptable'<br>
> psql:/usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so" \
target="_blank">rtpostgis-2.2.so</a>: undefined symbol 'SPI_result'<br> > \
psql:/usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so" \
target="_blank">rtpostgis-2.2.so</a>: undefined symbol<br> > \
'InterruptPending'<br> > psql:/usr/local/pgsql/lib/<a \
href="http://rtpostgis-2.2.so" target="_blank">rtpostgis-2.2.so</a>: undefined \
symbol<br> > 'SPI_processed'<br>
> psql (9.2.4)<br>
> (...)<br>
><br>
> In fact, I´ve been trying to solve this since a long time ago, and with many<br>
> previous versions of both Postgresql and Postgis, but I´m really stuck<br>
</div>Also, what is the output of this command? => ldd<br>
/usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so" \
target="_blank">rtpostgis-2.2.so</a><br> Are you sure that rtpostgis is linked to the \
necessary PG libs?<br></blockquote><div><br></div></div></div><div>Sure, I´ve tried \
this, here´s the output:</div><div><br></div><div># ldd /usr/local/pgsql/lib/<a \
href="http://rtpostgis-2.1.so" target="_blank">rtpostgis-2.1.so</a> </div>
<div><a href="http://rtpostgis-2.1.so" \
target="_blank">rtpostgis-2.1.so</a>:</div><div> Start End Type Open \
Ref GrpRef Name</div><div> 06460000 26485000 dlib 1 0 0 \
/usr/local/pgsql/lib/<a href="http://rtpostgis-2.1.so" \
target="_blank">rtpostgis-2.1.so</a></div>
<div> 07ae1000 27d8a000 rlib 0 1 0 \
/usr/local/lib/libgdal.so.18.1</div><div> 0f27b000 2f285000 rlib 0 2 0 \
/usr/local/lib/libgeos_c.so.9.2</div><div> 0717a000 27184000 rlib 0 1 0 \
/usr/local/lib/libproj.so.7.0</div>
<div> 06401000 26405000 rlib 0 1 0 \
/usr/local/lib/libjson.so.1.1</div><div> 04171000 24198000 rlib 0 2 0 \
/usr/local/lib/libxml2.so.14.0</div><div> 0c746000 2c74d000 rlib 0 5 0 \
/usr/lib/libz.so.4.1</div>
<div> 0783c000 2791c000 rlib 0 5 0 \
/usr/local/lib/libiconv.so.6.0</div><div> 0c04f000 2c058000 rlib 0 9 0 \
/usr/lib/libm.so.7.1</div><div> 02fb1000 22ff4000 rlib 0 2 0 \
/usr/local/lib/libgeos.so</div>
<div> 012fa000 21308000 rlib 0 1 0 \
/usr/lib/libsqlite3.so.21.0</div><div> 0603b000 26040000 rlib 0 1 0 \
/usr/lib/libexpat.so.10.0</div><div> 071ae000 271bd000 rlib 0 1 0 \
/usr/local/lib/libjasper.so.2.1</div>
<div> 04278000 2427c000 rlib 0 1 0 \
/usr/local/lib/libgif.so.5.4</div><div> 0894b000 28951000 rlib 0 1 0 \
/usr/local/lib/libjpeg.so.64.0</div><div> 035b6000 235bd000 rlib 0 1 0 \
/usr/local/lib/libpng.so.15.14</div>
<div> 0cba6000 2cbae000 rlib 0 1 0 \
/usr/local/lib/libpq.so.5.6</div><div> 0856a000 28576000 rlib 0 1 0 \
/usr/local/lib/libcurl.so.23.0</div><div> 04989000 249b5000 rlib 0 2 0 \
/usr/local/lib/libidn.so.17.0</div>
<div> 03a50000 23a54000 rlib 0 3 0 \
/usr/local/lib/libintl.so.6.0</div><div> 087de000 287eb000 rlib 0 3 0 \
/usr/lib/libssl.so.19.0</div><div> 0cea6000 2cee5000 rlib 0 3 0 \
/usr/lib/libcrypto.so.22.0</div>
<div> 0955d000 2958b000 rlib 0 3 0 \
/usr/lib/libstdc++.so.55.0</div><div><br></div><div>For sure there must be some lib \
I´m missing, but I can´t divise which one.</div><div>As you can see, there´s no other \
linked lib from pgsql/lib.</div>
<div><br></div><div>Any ideas?</div><div><br></div><div>Thanks a lot. \
Best,</div><div>Marcelo</div><span class="HOEnZb"><font color="#888888"><div> \
</div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<span><font color="#888888">--<br>
Michael<br>
</font></span></blockquote></font></span></div><div \
class="im"><br><br></div></div></div></div>-- <br>Editio Princeps<br><a \
href="http://www.editioprinceps.com">http://www.editioprinceps.com</a> </div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic