Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)

On Mon, Dec 18, 2017 at 08:56:35AM -0600, Justin Pryzby wrote:
> On Sat, Dec 16, 2017 at 01:01:01PM -0600, Justin Pryzby wrote:
> > On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote:
> >
> > > > proj
> > >
> > > Please grab this from EPEL:
> > >
> > > https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/
> >
> > For centos6, I think there's an issue with the version of proj in EPEL combined
> > with postgis10_24:
> >
> > [pryzbyj(at)db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head
> ...
> > psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:94: ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: pj_get_spheroid_defn
>
> I meant to also say:
> I think that indicates a missing dependency version in the postgis package. I
> know that in debian, this kind of thing is handled by dpkg-shlibdeps.

I was doing another deployment (ansible) and again ran into same issue (I
think):

TASK: [legacy_appserver | create postgis environment] *************************
failed: [new.gta] => {"failed": true, "item": ""}
msg: Database query failed: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: geod_init

gdal-libs.x86_64 1.9.2-8.rhel6 @pgdg10
geos.x86_64 3.5.0-1.rhel6 @pgdg10
geos36.x86_64 3.6.2-2.rhel6 @pgdg10
geos36-devel.x86_64 3.6.2-2.rhel6 @pgdg10

libgeotiff.x86_64 1.4.0-1.rhel6 @pgdg96
postgis24_10.x86_64 2.4.2-3.rhel6 @pgdg10
proj.x86_64 4.8.0-2.rhel6 @pgdg10
libspatialite.x86_64 2.4.0-0.6.RC4.el6 @epel

I see:
https://trac.osgeo.org/postgis/ticket/3142

[pryzbyj(at)gta-mtx-telsa ~]$ yum list --showdu proj
Loaded plugins: etckeeper, fastestmirror, security
Loading mirror speeds from cached hostfile
* base: centos.mirror.ndchost.com
* epel: mirror.sjc02.svwh.net
* extras: mirror.lax.hugeserver.com
* ius: mirror.team-cymru.org
* updates: mirrors.usc.edu
Installed Packages
proj.x86_64 4.8.0-2.rhel6 @pgdg10
Available Packages
proj.i686 4.7.0-1.el6 epel
proj.x86_64 4.7.0-1.el6 epel
proj.x86_64 4.8.0-2.rhel6 pgdg10
proj.x86_64 4.8.0-2.rhel6 pgdg96

I was able to work around by doing:
sudo yum downgrade postgis24_10{,-client,-utils}-2.4.2-1.rhel6

Was the postgis24_10 built against a proj from centos7 or not available in
repo?

--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581