BUG #15029: Cannot create postgis extension after install

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: rdb(at)ybits(dot)net
Subject: BUG #15029: Cannot create postgis extension after install
Date: 2018-01-24 20:51:16
Message-ID: 20180124205116.25009.89011@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15029
Logged by: Ryan Bowman
Email address: rdb(at)ybits(dot)net
PostgreSQL version: 10.1
Operating system: CentOS release 6.9 (Final)
Description:

After installing (via yum) and initializing our postgres 10.1 server, I'm
unable to create the postgis extension without manually building and
installing the latest release of postgis 2.4 (2.4.2):

> yum install
https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgdg-centos10-10-2.noarch.rpm

> yum install postgresql10-server postgresql10-devel postgresql10-contrib
postgis24_10 postgis24_10-client postgis24_10-utils postgis24_10-devel
postgresql10-plperl

> /etc/init.d/postgresql-10 initdb

> /usr/pgsql-10/bin/psql -c "create extension postgis"
ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so":
/usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: geod_init

I should note that we have an existing version of postgres 9.2 installed; I
don't see how that could be interfering but it's worth noting.

I was able to get around this issue, as I mentioned above, by manually
downloading, building and installing postgis-2.4.2

I think I've included everything here; if I'm missing something obvious, do
let me know :)

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2018-01-24 22:20:07 Re: defaut value '1' in smallint column is a string value '1' in pgsql >= 9.5
Previous Message PG Bug reporting form 2018-01-24 19:13:41 BUG #15028: PostGIS won't install/yum update fails due to gdal-libs package dependency problem