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

From: David Markham <david(dot)markham(at)ericsson(dot)com>
To: "pgsql-pkg-yum(at)postgresql(dot)org" <pgsql-pkg-yum(at)postgresql(dot)org>
Subject: Unable to create postgis 2.1.5 extension in PG9.2.8/rhel6
Date: 2015-02-03 03:35:15
Message-ID: CF20DC734EC2674F80F9832A93EAD89F632B29E5@ESGSCMB105.ericsson.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Devrim Gündüz 2015-02-03 10:58:50 Re: PGDG repo differences for RHEL 6.6 / 7.
Previous Message Graeme B. Bell 2015-02-02 13:47:48 Re: PGDG repo differences for RHEL 6.6 / 7.