[postgis-users] OpenBSd installation problem

[dustymugs]

Marcelo,

See if rtpostgis-2.2.so can find the PostgreSQL libs.

ldd /usr/local/pgsql/lib/rtpostgis-2.2.so

-bborie

On 07/10/2013 12:32 PM, Marcelo Bacha wrote:
> Thanks Bborie.
> 
> 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.
> Here´s how it´s configured:
> 
> ./configure --enable-depend --with-openssl --with-libxml --with-libxslt
> --with-perl --enable-debug --disable-thread-safety
> 
> I´m running out of ideas...
> 
> Best,
> Marcelo
> 
> 
> On Mon, Jul 1, 2013 at 5:19 PM, Bborie Park <dustymugs at gmail.com> wrote:
> 
>> Marcelo,
>>
>> Those missing symbols are all from PostgreSQL. You'll want to make
>> sure the PostgreSQL libs and dev files are provided.
>>
>> -bborie
>>
>> On Mon, Jul 1, 2013 at 1:17 PM, Marcelo Bacha <dronsz at gmail.com> wrote:
>>> Hi,
>>>
>>> This is my first posting, I´m new to Postgis. I´ve seen similar problems
>>> related in lists all around, but this one, I couldn´t manage to solve.
>>>
>>> I have an OpenBSD 5.3 server, with PostgreSQL 9.2.4 on it, which always
>>> worked fine. I have to transfer some geospatial databases from a Windows
>>> server, so I downloaded Postgis from the source (I needed the latest
>>> versions), configured, compiled & installed it.
>>> Everything seems to be fine, but when I try to create the postgis
>> extension
>>> (with raster support) 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
>>>
>>> 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
>>>
>>> (I know it´s the development, and not the stable release, but the results
>>> are the same with all other releases.)
>>>
>>> When I try to preload the rtpostgis shared object setting the LD_PRELOAD
>>> environment variable, I get this 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)
>>>
>>> Didn´t find any further useful info setting LD_DEBUG (I may list the
>> output
>>> if necessary, anyway).
>>>
>>> Any hint on how to solve this? I´m running out of ideas.
>>>
>>> Thanks in advance,
>>> Marcelo
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
> 
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>