BUG #14989: Postgis 2.4.2 for PostgreSQL 10 fails to install - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      14989
Logged by:          James Roos
Email address:      roosj@leidos.com
PostgreSQL version: 10.1
Operating system:   CentOS 6.9
Description:

After installing PostgreSQL 10.1 on a fresh CentOS 6.9 system I attempted to
install the PostGIS 2.4 extension.  The basic procedures followed are:

# yum install -y
https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgdg-centos10-10-2.noarch.rpm
# yum install -y epel-release

# yum install postgresql10-server postgresql10 postgresql10-contrib

PostgreSQL 10.1 successfully installs

# yum install postgis24_10

Loaded plugins: fastestmirror, remove-with-leaves
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: mirror.rackspace.com
 * epel: mirror.compevo.com
 * extras: repos.forethought.net
 * updates: mirror.lax.hugeserver.com
Resolving Dependencies
--> Running transaction check
---> Package postgis24_10.x86_64 0:2.4.2-3.rhel6 will be installed
--> Processing Dependency: geos36 >= 3.6.2 for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: gdal-libs >= 1.9.0 for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: proj49 for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: json-c for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: hdf5 for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: libproj.so.12()(64bit) for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: libproj.so.0()(64bit) for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: libjson-c.so.2()(64bit) for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: libgeos_c.so.1()(64bit) for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Processing Dependency: libgdal.so.1()(64bit) for package:
postgis24_10-2.4.2-3.rhel6.x86_64
--> Running transaction check
---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed
--> Processing Dependency: libpng12.so.0(PNG12_0)(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libjpeg.so.62(LIBJPEG_6.2)(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libxerces-c-3.0.so()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libtiff.so.3()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libspatialite.so.2()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libpoppler.so.5()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libpng12.so.0()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libodbcinst.so.2()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libodbc.so.2()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libnetcdf.so.6()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libjpeg.so.62()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libjasper.so.1()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libgta.so.0()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libgif.so.4()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libgeotiff.so.2()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libfreexl.so.1()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libdapserver.so.7()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libdapclient.so.3()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libdap.so.11()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libcfitsio.so.0()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libarmadillo.so.4()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
--> Processing Dependency: libCharLS.so.1()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
---> Package geos36.x86_64 0:3.6.2-2.rhel6 will be installed
---> Package geos36-devel.x86_64 0:3.6.2-2.rhel6 will be installed
---> Package hdf5.x86_64 0:1.8.5.patch1-10.el6 will be installed
--> Processing Dependency: libgfortran.so.3(GFORTRAN_1.0)(64bit) for
package: hdf5-1.8.5.patch1-10.el6.x86_64
--> Processing Dependency: libgfortran.so.3()(64bit) for package:
hdf5-1.8.5.patch1-10.el6.x86_64
---> Package json-c.x86_64 0:0.11-13.el6 will be installed
---> Package proj.x86_64 0:4.8.0-2.rhel6 will be installed
---> Package proj49.x86_64 0:4.9.3-3.rhel6 will be installed
--> Running transaction check
---> Package CharLS.x86_64 0:1.0-5.el6 will be installed
---> Package armadillo.x86_64 0:4.550.2-1.el6 will be installed
--> Processing Dependency: libarpack.so.2()(64bit) for package:
armadillo-4.550.2-1.el6.x86_64
--> Processing Dependency: libblas.so.3()(64bit) for package:
armadillo-4.550.2-1.el6.x86_64
--> Processing Dependency: libcblas.so.3()(64bit) for package:
armadillo-4.550.2-1.el6.x86_64
--> Processing Dependency: libclapack.so.3()(64bit) for package:
armadillo-4.550.2-1.el6.x86_64
--> Processing Dependency: liblapack.so.3()(64bit) for package:
armadillo-4.550.2-1.el6.x86_64
---> Package cfitsio.x86_64 0:3.240-3.el6 will be installed
---> Package freexl.x86_64 0:1.0.4-1.el6 will be installed
---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed
--> Processing Dependency: libgeotiff.so.2()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
---> Package giflib.x86_64 0:4.1.6-3.1.el6 will be installed
--> Processing Dependency: libX11.so.6()(64bit) for package:
giflib-4.1.6-3.1.el6.x86_64
--> Processing Dependency: libSM.so.6()(64bit) for package:
giflib-4.1.6-3.1.el6.x86_64
--> Processing Dependency: libICE.so.6()(64bit) for package:
giflib-4.1.6-3.1.el6.x86_64
---> Package jasper-libs.x86_64 0:1.900.1-21.el6_9 will be installed
---> Package libdap.x86_64 0:3.11.0-1.el6 will be installed
---> Package libgfortran.x86_64 0:4.4.7-18.el6 will be installed
---> Package libgta.x86_64 0:1.0.2-2.el6 will be installed
---> Package libjpeg-turbo.x86_64 0:1.2.1-3.el6_5 will be installed
---> Package libpng.x86_64 2:1.2.49-2.el6_7 will be installed
---> Package libspatialite.x86_64 0:2.4.0-0.6.RC4.el6 will be installed
---> Package libtiff.x86_64 0:3.9.4-21.el6_8 will be installed
---> Package netcdf.x86_64 0:4.1.1-3.el6.5 will be installed
---> Package poppler.x86_64 0:0.12.4-12.el6_9 will be installed
--> Processing Dependency: poppler-data >= 0.4.0 for package:
poppler-0.12.4-12.el6_9.x86_64
--> Processing Dependency: libopenjpeg.so.2()(64bit) for package:
poppler-0.12.4-12.el6_9.x86_64
--> Processing Dependency: liblcms.so.1()(64bit) for package:
poppler-0.12.4-12.el6_9.x86_64
--> Processing Dependency: libfreetype.so.6()(64bit) for package:
poppler-0.12.4-12.el6_9.x86_64
--> Processing Dependency: libfontconfig.so.1()(64bit) for package:
poppler-0.12.4-12.el6_9.x86_64
---> Package unixODBC.x86_64 0:2.2.14-14.el6 will be installed
--> Processing Dependency: libltdl.so.7()(64bit) for package:
unixODBC-2.2.14-14.el6.x86_64
---> Package xerces-c.x86_64 0:3.0.1-20.el6 will be installed
--> Running transaction check
---> Package arpack.x86_64 0:3.1.3-1.el6 will be installed
---> Package atlas.x86_64 0:3.8.4-2.el6 will be installed
---> Package blas.x86_64 0:3.2.1-5.el6 will be installed
---> Package fontconfig.x86_64 0:2.8.0-5.el6 will be installed
---> Package freetype.x86_64 0:2.3.11-17.el6 will be installed
---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed
--> Processing Dependency: libgeotiff.so.2()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
---> Package lcms-libs.x86_64 0:1.19-1.el6 will be installed
---> Package libICE.x86_64 0:1.0.6-1.el6 will be installed
---> Package libSM.x86_64 0:1.2.1-2.el6 will be installed
---> Package libX11.x86_64 0:1.6.4-3.el6 will be installed
--> Processing Dependency: libX11-common = 1.6.4-3.el6 for package:
libX11-1.6.4-3.el6.x86_64
--> Processing Dependency: libxcb.so.1()(64bit) for package:
libX11-1.6.4-3.el6.x86_64
---> Package libtool-ltdl.x86_64 0:2.2.6-15.5.el6 will be installed
---> Package openjpeg-libs.x86_64 0:1.3-16.el6_8 will be installed
---> Package poppler-data.noarch 0:0.4.0-1.el6 will be installed
--> Running transaction check
---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed
--> Processing Dependency: libgeotiff.so.2()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
---> Package libX11-common.noarch 0:1.6.4-3.el6 will be installed
---> Package libxcb.x86_64 0:1.12-4.el6 will be installed
--> Processing Dependency: libXau.so.6()(64bit) for package:
libxcb-1.12-4.el6.x86_64
--> Running transaction check
---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed
--> Processing Dependency: libgeotiff.so.2()(64bit) for package:
gdal-libs-1.9.2-8.rhel6.x86_64
---> Package libXau.x86_64 0:1.0.6-4.el6 will be installed
--> Finished Dependency Resolution
Error: Package: gdal-libs-1.9.2-8.rhel6.x86_64 (pgdg10)
           Requires: libgeotiff.so.2()(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

As the above message indicates GDAL 1.9.2 is being used.  However,  on the
PostGIS Users Wiki
(https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS), PostGIS
2.4 requires GDAL 1.10 or greater.  

I was able to find the missing libgeotiff library in the libgeotiff package
available in the PostgreSQL 9.6 yum repository.  After installing the
package, the postgis24_10 package successfully installed.  However, when I
tried to add the PostGIS extension in a new database, I got the message:
ERROR:  could not load library "/usr/pgsql-10/lib/postgis-2.4.so":
/usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: geod_init

I suspect this is related to the wrong version of GDAL being identified in
the PostGIS dependencies.