Date: Tue, 19 Dec 2017 15:30:13 -0600
From: Justin Pryzby <pryzby@telsasoft.com>
To: Devrim =?iso-8859-1?B?R/xuZPx6?= <devrim@gunduz.org>
Cc: pgsql-pkg-yum@postgresql.org
Subject: Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
Message-ID: <20171219213013.GA22497@telsasoft.com>
References: <20171129100319.GA12026@telsasoft.com>
 <1511950968.5887.14.camel@gunduz.org>
 <20171207210245.GB14216@telsasoft.com>
 <20171208193313.GG14216@telsasoft.com>
 <1513307151.3398.15.camel@gunduz.org>
 <20171216190101.GP18184@telsasoft.com>
 <20171218145635.GT18184@telsasoft.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20171218145635.GT18184@telsasoft.com>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk

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@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@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