BUG #14950: RPM EPEL PostGIS24_10 install breaks "yum update" - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      14950
Logged by:          Karl Pinc
Email address:      kop@meme.com
PostgreSQL version: 10.1
Operating system:   RHEL 7
Description:

Hi,

Installing PostGIS on RHEL 7 from the PG repos breaks yum, to the point
where no further yum updates can be done.  Not being able to apply security
updates is bad. :)

The work-around seems to be to un-install libgeotiff, which un-installs
PostGIS, then "yum update", then re-install PostGIS.

The PG RPM repos contain a PostGIS rpm.  To install this the epel repo must
be enabled.  But dependencies break and yum won't upgrade anything after
installation of PostGIS.

Here's what happens if you try to install PostGIS without epel enabled:

-----------------<snip>---------------
# yum install postgis24_10
Loaded plugins: langpacks, product-id, search-disabled-repos,
subscription-
              : manager
Resolving Dependencies
--> Running transaction check
---> Package postgis24_10.x86_64 0:2.4.2-1.rhel7 will be installed
--> Processing Dependency: gdal-libs >= 1.9.0 for package:
postgis24_10-2.4.2-1.rhel7.x86_64
--> Processing Dependency: libgdal.so.1()(64bit) for package:
postgis24_10-2.4.2-1.rhel7.x86_64
--> Finished Dependency Resolution
Error: Package: postgis24_10-2.4.2-1.rhel7.x86_64 (pgdg10)
           Requires: libgdal.so.1()(64bit)
Error: Package: postgis24_10-2.4.2-1.rhel7.x86_64 (pgdg10)
           Requires: gdal-libs >= 1.9.0
**********************************************************************
yum can be configured to try to resolve such errors by temporarily
enabling
disabled repos and searching for missing dependencies.
To enable this functionality please set 'notify_only=0' in
/etc/yum/pluginconf.d/search-disabled-repos.conf
**********************************************************************

Error: Package: postgis24_10-2.4.2-1.rhel7.x86_64 (pgdg10)
           Requires: libgdal.so.1()(64bit)
Error: Package: postgis24_10-2.4.2-1.rhel7.x86_64 (pgdg10)
           Requires: gdal-libs >= 1.9.0
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
-----------------<snip>---------------

Enable the epel repo and PostGIS installs, like so:
-----------------<snip>---------------
# yum install postgis24_10
Loaded plugins: langpacks, product-id, search-disabled-repos,
subscription-
              : manager
epel/x86_64/metalink                                     |  16 kB     00:00
   
Resolving Dependencies
--> Running transaction check
---> Package postgis24_10.x86_64 0:2.4.2-1.rhel7 will be installed
--> Processing Dependency: gdal-libs >= 1.9.0 for package:
postgis24_10-2.4.2-1.rhel7.x86_64
--> Processing Dependency: libgdal.so.1()(64bit) for package:
postgis24_10-2.4.2-1.rhel7.x86_64
--> Running transaction check
---> Package gdal-libs.x86_64 0:1.11.4-1.el7 will be installed
--> Processing Dependency: libgeotiff.so.1.2()(64bit) for package:
gdal-libs-1.11.4-1.el7.x86_64
--> Running transaction check
---> Package libgeotiff.x86_64 0:1.2.5-14.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package              Arch           Version               Repository
Size
================================================================================
Installing:
 postgis24_10         x86_64         2.4.2-1.rhel7         pgdg10
6.3 M
Installing for dependencies:
 gdal-libs            x86_64         1.11.4-1.el7          epel
4.4 M
 libgeotiff           x86_64         1.2.5-14.el7          epel
545 k

Transaction Summary
================================================================================
Install  1 Package (+2 Dependent packages)

Total download size: 11 M
Installed size: 120 M
Is this ok [y/d/N]: y
Downloading packages:
gdal-libs-1.11.4-1.el7.x86_64. FAILED
  
http://mirror.es.its.nyu.edu/epel/7/x86_64/Packages/g/gdal-libs-1.11.4-1.el7.x86_64.rpm:
[Errno 12] Timeout on
http://mirror.es.its.nyu.edu/epel/7/x86_64/Packages/g/gdal-libs-1.11.4-1.el7.x86_64.rpm:
(28, 'Connection timed out after 30001 milliseconds')
Trying other mirror.
(1/3): libgeotiff-1.2.5-14.el7.x86_64.rpm                  | 545 kB   00:00
   
(2/3): gdal-libs-1.11.4-1.el7.x86_64.rpm                   | 4.4 MB   00:00
   
(3/3): postgis24_10-2.4.2-1.rhel7.x86_64.rpm               | 6.3 MB   00:01
   
--------------------------------------------------------------------------------
Total                                              368 kB/s |  11 MB  00:31
   
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : libgeotiff-1.2.5-14.el7.x86_64
1/3 
  Installing : gdal-libs-1.11.4-1.el7.x86_64
2/3 
  Installing : postgis24_10-2.4.2-1.rhel7.x86_64
3/3 
  Verifying  : gdal-libs-1.11.4-1.el7.x86_64
1/3 
  Verifying  : postgis24_10-2.4.2-1.rhel7.x86_64
2/3 
  Verifying  : libgeotiff-1.2.5-14.el7.x86_64
3/3 

Installed:
  postgis24_10.x86_64 0:2.4.2-1.rhel7
   

Dependency Installed:
  gdal-libs.x86_64 0:1.11.4-1.el7        libgeotiff.x86_64 0:1.2.5-14.el7
   

Complete!
-----------------<snip>---------------

But then, if you try to update your system with yum, it never works:
-----------------<snip>---------------
# yum update
Loaded plugins: langpacks, product-id, search-disabled-repos,
subscription-
              : manager
Resolving Dependencies
--> Running transaction check
---> Package libgeotiff.x86_64 0:1.2.5-14.el7 will be updated
--> Processing Dependency: libgeotiff.so.1.2()(64bit) for package:
gdal-libs-1.11.4-1.el7.x86_64
---> Package libgeotiff.x86_64 0:1.4.0-1.rhel7 will be an update
--> Finished Dependency Resolution
Error: Package: gdal-libs-1.11.4-1.el7.x86_64 (@epel)
           Requires: libgeotiff.so.1.2()(64bit)
           Removing: libgeotiff-1.2.5-14.el7.x86_64 (@epel)
               libgeotiff.so.1.2()(64bit)
           Updated By: libgeotiff-1.4.0-1.rhel7.x86_64 (pgdg10)
               Not found
**********************************************************************
yum can be configured to try to resolve such errors by temporarily
enabling
disabled repos and searching for missing dependencies.
To enable this functionality please set 'notify_only=0' in
/etc/yum/pluginconf.d/search-disabled-repos.conf
**********************************************************************

Error: Package: gdal-libs-1.11.4-1.el7.x86_64 (@epel)
           Requires: libgeotiff.so.1.2()(64bit)
           Removing: libgeotiff-1.2.5-14.el7.x86_64 (@epel)
               libgeotiff.so.1.2()(64bit)
           Updated By: libgeotiff-1.4.0-1.rhel7.x86_64 (pgdg10)
               Not found
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
-----------------<snip>---------------

Regards,
Karl