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

From Marcelo Bacha
Subject Postgis extension bug w/ OpenBSD
Date
Msg-id CAOfDtHPsaHgoMjwk+kqoOit5yBbexzUOdrXNZH7=AxGF9zWoJg@mail.gmail.com
Whole thread Raw
Responses Re: Postgis extension bug w/ OpenBSD  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
Hi,

I=B4ve sent this to the Postgis bug list before, but I was told that this i=
s
probably a PostgreSQL problem.

I have an OpenBSD 5.3 server, with PostgreSQL 9.3.0, which seems to work
fine. I=B4m trying to install  on it, which always worked fine.
When I try to install the extension for Postgis 2.1.0, I get this error 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*

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=B4ve been trying to solve this since a long time ago, and with
many previous versions of both Postgresql and Postgis, but I=B4m really stu=
ck

Thanks in advance,
Marcelo




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

pgsql-bugs by date:

Previous
From: Murat Kabilov
Date:
Subject: Problem with updating hstore extension from 9.2 to 9.3
Next
From: sstewart.fr@gmail.com
Date:
Subject: BUG #8460: Stack Builder fails to parse http://www.postgresql.org/applications-v2.xml