Unable to create postgis 2.1.5 extension in PG9.2.8/rhel6 - Mailing list pgsql-pkg-yum

From David Markham
Subject Unable to create postgis 2.1.5 extension in PG9.2.8/rhel6
Date
Msg-id CF20DC734EC2674F80F9832A93EAD89F632B29E5@ESGSCMB105.ericsson.se
Whole thread Raw
Responses Re: Unable to create postgis 2.1.5 extension in PG9.2.8/rhel6  (Devrim Gündüz <devrim@gunduz.org>)
List 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 by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: PGDG repo differences for RHEL 6.6 / 7.
Next
From: Devrim Gündüz
Date:
Subject: Re: PGDG repo differences for RHEL 6.6 / 7.