<div dir="ltr">Here´s the output:<div><br></div><div><div># ldd /usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so">rtpostgis-2.2.so</a> </div><div>/usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so">rtpostgis-2.2.so</a>:</div>
<div> Start End Type Open Ref GrpRef Name</div><div> 0ee98000 2eebd000 dlib 1 0 0 /usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so">rtpostgis-2.2.so</a></div><div> 08a43000 28cec000 rlib 0 1 0 /usr/local/lib/libgdal.so.18.0</div>
<div> 041ef000 241f9000 rlib 0 2 0 /usr/local/lib/libgeos_c.so.8.8</div><div> 003f6000 20400000 rlib 0 1 0 /usr/local/lib/libproj.so.7.0</div><div> 0e834000 2e838000 rlib 0 1 0 /usr/local/lib/libjson.so.1.1</div>
<div> 0a36a000 2a391000 rlib 0 2 0 /usr/local/lib/libxml2.so.14.0</div><div> 06045000 2604c000 rlib 0 5 0 /usr/lib/libz.so.4.1</div><div> 0fce8000 2fdc8000 rlib 0 5 0 /usr/local/lib/libiconv.so.6.0</div>
<div> 059df000 259e8000 rlib 0 9 0 /usr/lib/libm.so.7.1</div><div> 064e4000 26526000 rlib 0 2 0 /usr/local/lib/libgeos.so</div><div> 0dfef000 2dffd000 rlib 0 1 0 /usr/lib/libsqlite3.so.21.0</div>
<div> 07bdf000 27be4000 rlib 0 1 0 /usr/lib/libexpat.so.10.0</div><div> 007b8000 207c7000 rlib 0 1 0 /usr/local/lib/libjasper.so.2.1</div><div> 0ae63000 2ae67000 rlib 0 1 0 /usr/local/lib/libgif.so.5.4</div>
<div> 077d1000 277d7000 rlib 0 1 0 /usr/local/lib/libjpeg.so.64.0</div><div> 0978e000 29795000 rlib 0 1 0 /usr/local/lib/libpng.so.15.14</div><div> 09594000 2959c000 rlib 0 1 0 /usr/local/lib/libpq.so.5.5</div>
<div> 00a2d000 20a39000 rlib 0 1 0 /usr/local/lib/libcurl.so.23.0</div><div> 05f63000 25f8f000 rlib 0 2 0 /usr/local/lib/libidn.so.17.0</div><div> 02e03000 22e07000 rlib 0 3 0 /usr/local/lib/libintl.so.6.0</div>
<div> 0ab0d000 2ab1a000 rlib 0 3 0 /usr/lib/libssl.so.19.0</div><div> 0d71c000 2d75b000 rlib 0 3 0 /usr/lib/libcrypto.so.22.0</div><div> 094ce000 294fc000 rlib 0 3 0 /usr/lib/libstdc++.so.55.0</div>
</div><div><br></div><div>Indeed, there´s no shared object from /usr/local/pgsql/lib, is this correct?</div><div><br></div><div>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:</div>
<div><br></div><div><div># ldconfig -r | grep pgsql</div><div> search directories: /usr/lib:/usr/X11R6/lib:/usr/local/lib:/usr/local/pgsql/lib</div><div> 328:-lpgtypes.3.3 => /usr/local/pgsql/lib/libpgtypes.so.3.3</div>
<div> 329:-lecpg.6.4 => /usr/local/pgsql/lib/libecpg.so.6.4</div><div> 331:-lecpg_compat.3.4 => /usr/local/pgsql/lib/libecpg_compat.so.3.4</div></div><div><br></div><div>Marcelo</div><div><br></div><div>
<br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jul 10, 2013 at 5:06 PM, dustymugs <span dir="ltr"><<a href="mailto:dustymugs@gmail.com" target="_blank">dustymugs@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Marcelo,<br>
<br>
See if <a href="http://rtpostgis-2.2.so" target="_blank">rtpostgis-2.2.so</a> can find the PostgreSQL libs.<br>
<br>
ldd /usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so" target="_blank">rtpostgis-2.2.so</a><br>
<span class="HOEnZb"><font color="#888888"><br>
-bborie<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
On 07/10/2013 12:32 PM, Marcelo Bacha wrote:<br>
> Thanks Bborie.<br>
><br>
> I went back to PostgreSQL, to check the warnings from compilation. I<br>
> Corrected a couple of things, applied a recent patch for the configure<br>
> properly recognize sys/ucred.h, and so on, but nothing changed the<br>
> situation.<br>
> Here´s how it´s configured:<br>
><br>
> ./configure --enable-depend --with-openssl --with-libxml --with-libxslt<br>
> --with-perl --enable-debug --disable-thread-safety<br>
><br>
> I´m running out of ideas...<br>
><br>
> Best,<br>
> Marcelo<br>
><br>
><br>
> On Mon, Jul 1, 2013 at 5:19 PM, Bborie Park <<a href="mailto:dustymugs@gmail.com">dustymugs@gmail.com</a>> wrote:<br>
><br>
>> Marcelo,<br>
>><br>
>> Those missing symbols are all from PostgreSQL. You'll want to make<br>
>> sure the PostgreSQL libs and dev files are provided.<br>
>><br>
>> -bborie<br>
>><br>
>> On Mon, Jul 1, 2013 at 1:17 PM, Marcelo Bacha <<a href="mailto:dronsz@gmail.com">dronsz@gmail.com</a>> wrote:<br>
>>> Hi,<br>
>>><br>
>>> This is my first posting, I´m new to Postgis. I´ve seen similar problems<br>
>>> related in lists all around, but this one, I couldn´t manage to solve.<br>
>>><br>
>>> I have an OpenBSD 5.3 server, with PostgreSQL 9.2.4 on it, which always<br>
>>> worked fine. I have to transfer some geospatial databases from a Windows<br>
>>> server, so I downloaded Postgis from the source (I needed the latest<br>
>>> versions), configured, compiled & installed it.<br>
>>> Everything seems to be fine, but when I try to create the postgis<br>
>> extension<br>
>>> (with raster support) on 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>
>> ":<br>
>>> dlopen (/usr/local/pgsql/lib/<a href="http://rtpostgis-2.2.so" target="_blank">rtpostgis-2.2.so</a>) failed: Cannot load<br>
>> specified<br>
>>> object<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>
>>> (I know it´s the development, and not the stable release, but the results<br>
>>> are the same with all other releases.)<br>
>>><br>
>>> When I try to preload the rtpostgis shared object setting the LD_PRELOAD<br>
>>> environment variable, I get this on psql:<br>
>>><br>
>>> $ psql<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<br>
>> '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>
>>> Didn´t find any further useful info setting LD_DEBUG (I may list the<br>
>> output<br>
>>> if necessary, anyway).<br>
>>><br>
>>> Any hint on how to solve this? I´m running out of ideas.<br>
>>><br>
>>> Thanks in advance,<br>
>>> Marcelo<br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> postgis-users mailing list<br>
>>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
>>><br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
>><br>
><br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Editio Princeps<br><a href="http://www.editioprinceps.com">http://www.editioprinceps.com</a>
</div>