<div dir="ltr">Thanks Bborie.<div><br></div><div>I went back to PostgreSQL, to check the warnings from compilation. I Corrected a couple of things, applied a recent patch for the configure properly recognize sys/ucred.h, and so on, but nothing changed the situation.</div>
<div>Hereīs how itīs configured:</div><div><br></div><div>./configure --enable-depend --with-openssl --with-libxml --with-libxslt --with-perl --enable-debug --disable-thread-safety<br></div><div><br></div><div>Iīm running out of ideas...</div>
<div><br></div><div>Best,</div><div>Marcelo</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 1, 2013 at 5:19 PM, Bborie Park <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>
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>
<div><div class="h5"><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 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>
> 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>
><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 '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 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>
</div></div>> _______________________________________________<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>
</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>