postgis missing dependencies in RHEL 7.9

[dannyim]

I am installing postgresql 12 with postgis 3.0 on a RHEL 7.9 machine and got the following error:

TASK [ANXS.postgresql : PostgreSQL | Extensions | Make sure the postgis extensions are installed | RedHat] *************************************************************************************************
fatal: [dev_db]: FAILED! => {"changed": false, "changes": {"installed": ["postgis30_12"]}, "msg": "Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
    Requires: libproj.so.19(
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
    Requires: libSFCGAL.so.1()(64bit)
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
    Requires: libgeotrror: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
    Requires: libgdal.so.29()(64bit)
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
    Requires: gdal33-libs1
    Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
    Requires: SFCGAL
    Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
    Requires: geos39 >= 3.9.1
    Error:: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
    Requires: proj72 >= 7.2.1
    ", "rc": 1, "results": ["Loaded plugins: enabled_repos_upload, package_upload, product-id, search-
              : -repos, subscription-manager
Resolving Dependencies
--> Running transaction check
---> Package postgis30_12.x86_64 0:3.0.4-1.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for packtgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: geos39 >= 3.9.1 for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: gdal33-libs >= 3.3.1 for package: postgis30_12-3.0.4-186_64
--> Processing Dependency: xerces-c for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libprotobuf-c.so.1(LIBPROTOBUF_C_1.0.0)(64bit) for package: postgis30_12-3.0.4-1.rhel7
--> Processing Dependency: libgeotiff16 for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: hdf5 for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: SFCGAL fge: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libtiff.so.5()(64bit) for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libprotobuf-c.so.1()(64bit) for package: 0_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libgeos_c.so.1()(64bit) for package: postgis30_12-3.el7.x86_64
--> Processing Dependency: libgdal.so.29()(64bit) for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: postgis30_12-3.0.4-1.rhel7.x86 Running transaction check
---> Package geos.x86_64 0:3.4.2-2.el7 will be installed
---> Package hdf5.x86_64 0:1.8.12-13.el7 will be installed
--> Processing Dependency: libgfortran.so.3(GFORTRAN_1.0)(or package: hdf5-1.8.12-13.el7.x86_64
--> Processing Dependency: libgfortran.so.3()(64bit) for package: hdf5-1.8.12-13.el7.x86_64
--> Processing Dependency: libquadmath.so.0()(64bit) for package: hdf5-1.el7.x86_64
--> Processing Dependency: libsz.so.2()(64bit) for package: hdf5-1.8.12-13.el7.x86_64
---> Package libtiff.x86_64 0:4.0.3-35.el7 will be installed
--> Processing Dependency: libjpeg.so.62(L.2)(64bit) for package: libtiff-4.0.3-35.el7.x86_64
--> Processing Dependency: libjpeg.so.62()(64bit) for package: libtiff-4.0.3-35.el7.x86_64
--> Processing Dependency: libjbig.so.2.0()(64bit) for packtiff-4.0.3-35.el7.x86_64
---> Package libxerces-c-3_2.x86_64 0:3.2.3-3.1 will be installed
---> Package postgis30_12.x86_64 0:3.0.4-1.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 age: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: geos39 >= 3.9.1 for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: gdal33-libs >= 3.3.1 for package: postgis30_12.rhel7.x86_64
--> Processing Dependency: libgeotiff16 for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Depelibproj.so.19()(64bit) for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libgdal.so.29()(64bit) for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libSFCGA(64bit) for package: postgis30_12-3.0.4-1.rhel7.x86_64
---> Package protobuf-c.x86_64 0:1.0.2-3.el7 will be installed
--> Running transaction check
---> Package jbigkit-libs.x86_64 0:2.0-11.el7 will beed
---> Package libaec.x86_64 0:1.0.4-1.el7 will be installed
---> Package libgfortran.x86_64 0:4.8.5-44.el7 will be installed
---> Package libjpeg-turbo.x86_64 0:1.2.90-8.el7 will be installed
---> Pibquadmath.x86_64 0:4.8.5-44.el7 will be installed
---> Package postgis30_12.x86_64 0:3.0.4-1.rhel7 will be installed
--> Processing Dependency: proj72 >= 7.2.1 for package: postgis30_12-3.0.4-1.rhel7.x-> Processing Dependency: geos39 >= 3.9.1 for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: gdal33-libs >= 3.3.1 for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dep libgeotiff16 for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: SFCGAL for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libproj.so.19()(64bit) for packagis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libgdal.so.29()(64bit) for package: postgis30_12-3.0.4-1.rhel7.x86_64
--> Processing Dependency: libSFCGAL.so.1()(64bit) for package: postgis30_12.rhel7.x86_64
--> Finished Dependency Resolution
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
           Requires: libproj.so.19()(64bit)
Error: Package: postgis30_12-3.0.4-1.rhel7.xostgresql)
           Requires: libSFCGAL.so.1()(64bit)
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
           Requires: libgeotiff16
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_gresql)
           Requires: libgdal.so.29()(64bit)
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
           Requires: gdal33-libs >= 3.3.1
Error: Package: postgis30_12-3.0.4-1.rhel7.postgresql)
           Requires: SFCGAL
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresql)
           Requires: geos39 >= 3.9.1
Error: Package: postgis30_12-3.0.4-1.rhel7.x86_64 (postgresq       Requires: proj72 >= 7.2.1
**********************************************************************
yum can be configured to try to resolve such errors by temporarily enabling
disabled repos and sefor missing dependencies.
To enable this functionality please set 'notify_only=0' in /etc/yum/pluginconf.d/search-disabled-repos.conf
********************************************************************ou could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
Uploading Enabled Repositories Report
Loaded plugins: product-id, subscription-manager

PLAY RECAP *************************************************************************************************************************************************************************************************

I ran my playbook with the following variables:

postgresql_version: 12
postgresql_ext_postgis_version: "3.0"
postgresql_ext_postgis_version_terse: "{{ postgresql_ext_postgis_version | replace('.','') }}"

postgresql_ext_postgis_deps:
  - "postgis{{ postgresql_ext_postgis_version_terse }}_{{ postgresql_version }}"

Based on what I could find, it looks like my error is due to the dependencies for postgis being moved to a new common yum repository

I searched the issues and found that pull request #479 fixed my issue. Could someone review that PR and perhaps merge it in?

Thanks

[github-actions]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!