public inbox for [email protected]  
help / color / mirror / Atom feed
From: Justin Pryzby <[email protected]>
To: Devrim Gündüz <[email protected]>
Cc: [email protected]
Subject: Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
Date: Sat, 16 Dec 2017 13:01:01 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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 ~]$ yum list --showdu proj
...
Installed Packages
proj.x86_64                                                                           4.7.0-1.el6                                                                             @epel
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                                                                           pgdg96

[pryzbyj@db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head
BEGIN
SET
DO
CREATE FUNCTION
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
psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:99: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:107: ERROR:  current transaction is aborted, commands ignored until end of transaction block

[pryzbyj@db ~]$ nm -D /usr/lib64/libproj.so.0.6.6 |grep pj_get_spheroid_defn || echo NOT FOUND
NOT FOUND

proj 4.8 from PGDG96 works ok:

[pryzbyj@db ~]$ psql 3rivers -qf /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql && echo OK
OK

[pryzbyj@db ~]$ sudo yum list --showduplicates postgis24_10{,-client,-utils} libgeotiff gdal-libs libspatialite proj
Loaded plugins: etckeeper, fastestmirror, security
Loading mirror speeds from cached hostfile
 * base: mirror.scalabledns.com
 * epel: mirror.chpc.utah.edu
 * extras: repos.forethought.net
 * ius: ord.mirror.rackspace.com
 * updates: repos.forethought.net
Installed Packages
gdal-libs.x86_64                                                                           1.9.2-8.rhel6                                                                     @pgdg10
libgeotiff.x86_64                                                                          1.4.0-1.rhel6                                                                     @pgdg96
libspatialite.x86_64                                                                       2.4.0-0.6.RC4.el6                                                                 @epel  
postgis24_10.x86_64                                                                        2.4.2-1.rhel6                                                                     @pgdg10
postgis24_10-client.x86_64                                                                 2.4.2-1.rhel6                                                                     @pgdg10
postgis24_10-utils.x86_64                                                                  2.4.2-1.rhel6                                                                     @pgdg10
proj.x86_64                                                                                4.8.0-2.rhel6                                                                     @pgdg96
Available Packages
gdal-libs.x86_64                                                                           1.9.2-8.rhel6                                                                     pgdg10 
gdal-libs.x86_64                                                                           1.9.2-8.rhel6                                                                     pgdg96 
libgeotiff.i686                                                                            1.2.5-6.el6                                                                       epel   
libgeotiff.x86_64                                                                          1.2.5-6.el6                                                                       epel   
libgeotiff.x86_64                                                                          1.4.0-1.rhel6                                                                     pgdg96 
libspatialite.i686                                                                         2.4.0-0.6.RC4.el6                                                                 epel   
libspatialite.x86_64                                                                       2.4.0-0.6.RC4.el6                                                                 epel   
postgis24_10.x86_64                                                                        2.4.1-1.rhel6                                                                     pgdg10 
postgis24_10.x86_64                                                                        2.4.2-1.rhel6                                                                     pgdg10 
postgis24_10-client.x86_64                                                                 2.4.1-1.rhel6                                                                     pgdg10 
postgis24_10-client.x86_64                                                                 2.4.2-1.rhel6                                                                     pgdg10 
postgis24_10-utils.x86_64                                                                  2.4.1-1.rhel6                                                                     pgdg10 
postgis24_10-utils.x86_64                                                                  2.4.2-1.rhel6                                                                     pgdg10 
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                                                                     pgdg96 

Thanks for your support in this and in building RPMs.

Justin




view thread (12+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox