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

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 ~]$ 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(at)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(at)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(at)db ~]$ psql 3rivers -qf /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql && echo OK
OK

[pryzbyj(at)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