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