Unable to create postgis 2.1.5 extension in PG9.2.8/rhel6

Поиск
Список
Период
Сортировка
От David Markham
Тема Unable to create postgis 2.1.5 extension in PG9.2.8/rhel6
Дата
Msg-id CF20DC734EC2674F80F9832A93EAD89F632B29E5@ESGSCMB105.ericsson.se
обсуждение исходный текст
Ответы Re: Unable to create postgis 2.1.5 extension in PG9.2.8/rhel6  (Devrim Gündüz <devrim@gunduz.org>)
Список pgsql-pkg-yum

Hi,

 

Many thanks for your efforts in producing these packages for the wider community!

 

For your information, we were seeing a problem creating the postgis extension after installing the postgis2_92-2.1.5-1.rhel6 RPM (from http://yum.postgresql.org/9.2/redhat/rhel-6.6-x86_64/)

 

The error seen with PostgreSQL 9.2.8 installed is as follows:

geodb=# CREATE EXTENSION postgis;

ERROR:  could not load library "/usr/pgsql-9.2/lib/postgis-2.1.so": /usr/pgsql-9.2/lib/postgis-2.1.so: undefined symbol: HeapTupleHeaderGetDatum

 

Reverting to the postgis2_92-2.1.3-1.rhel6 RPM (from the same location) allows this to work as expected:

geodb=# CREATE EXTENSION postgis;

CREATE EXTENSION

 

Further investigation indicated that the symbol in question was added in PostgreSQL 9.2.9, and upgrading our installation from PG 9.2.8 to 9.2.9 resolved the problem.

 

Putting aside whether or not the PostgreSQL API change in 9.2.9 is in line with minor version change guidelines, it suggests that the postgis2_92-2.1.5 packages (and later) should have an RPM dependency of postgresql92 >= 9.2.9 to avoid this error. There may be similar dependencies in other PG release streams, as it looks like that symbol also appeared somewhere between 9.3.0 and 9.3.5 as well.

 

Regards,

David

 

В списке pgsql-pkg-yum по дате отправления:

Предыдущее
От: "Graeme B. Bell"
Дата:
Сообщение: Re: PGDG repo differences for RHEL 6.6 / 7.
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: PGDG repo differences for RHEL 6.6 / 7.