Postgis extension bug w/ OpenBSD

From: Marcelo Bacha <dronsz(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Postgis extension bug w/ OpenBSD
Date: 2013-09-17 21:48:09
Message-ID: CAOfDtHPsaHgoMjwk+kqoOit5yBbexzUOdrXNZH7=AxGF9zWoJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I´ve sent this to the Postgis bug list before, but I was told that this is
probably a PostgreSQL problem.

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.
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*

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

Thanks in advance,
Marcelo

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message benny 2013-09-18 10:05:44 BUG #8461: PostgreSQL 9.3 pg_dump heap corruptions
Previous Message Murat Kabilov 2013-09-17 19:00:16 Problem with updating hstore extension from 9.2 to 9.3