Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) - Mailing list pgsql-pkg-yum
| From | Justin Pryzby |
|---|---|
| Subject | Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) |
| Date | |
| Msg-id | 20171216190101.GP18184@telsasoft.com Whole thread Raw |
| In response to | Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) (Devrim Gündüz <devrim@gunduz.org>) |
| Responses |
Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
|
| List | pgsql-pkg-yum |
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 untilend of transaction block psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:107: ERROR: current transaction is aborted, commands ignored untilend 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
pgsql-pkg-yum by date: