Invalid PostGIS 2.4 and 2.5 packages

Hi,

I'm trying to move from CentOS 8 to LinuxOracle 8 (as CentOS 8 support ends in 2 weeks).
We are still using Postgres 9.6 with PostGIS 2.4 (I know I know...)

But it looks like all the RPM packages from PGDG for PostGIS 2.4 and 2.5 are broken.
They all require proj72 and gdal32-libs which requires proj80.

So postgres ends up running with both proj libraries and when I try to restore the databases I get multiple errors:
free(): invalid pointer


I'm not a dnf expert but hopefully this shows you the current package dependencies and the version conflict with the proj lib.

sudo dnf repoquery --quiet --latest-limit 1 --deplist gdal32-libs | grep proj
  dependency: libproj.so.22()(64bit)
   provider: proj80-8.0.1-1.rhel8.x86_64
   provider: proj81-8.1.1-1.rhel8.x86_64
  dependency: proj80 >= 8.0.1
   provider: proj80-8.0.1-1.rhel8.x86_64

sudo dnf repoquery --quiet --latest-limit 1 --deplist postgis24_96 | grep 'proj\|gdal'
  dependency: gdal32-libs >= 3.2.0
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libgdal.so.28()(64bit)
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libproj.so.19()(64bit)
   provider: proj70-7.0.1-4.rhel8.x86_64
   provider: proj71-7.1.1-3.rhel8.x86_64
   provider: proj72-7.2.1-1.rhel8.x86_64
  dependency: proj72 >= 7.2.0
   provider: proj72-7.2.1-1.rhel8.x86_64

sudo dnf repoquery --quiet --latest-limit 1 --deplist postgis24_10 | grep 'proj\|gdal'
  dependency: gdal32-libs >= 3.2.0
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libgdal.so.28()(64bit)
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libproj.so.19()(64bit)
   provider: proj70-7.0.1-4.rhel8.x86_64
   provider: proj71-7.1.1-3.rhel8.x86_64
   provider: proj72-7.2.1-1.rhel8.x86_64
  dependency: proj72 >= 7.2.0
   provider: proj72-7.2.1-1.rhel8.x86_64

sudo dnf repoquery --quiet --latest-limit 1 --deplist postgis24_11 | grep 'proj\|gdal'
  dependency: gdal32-libs >= 3.2.0
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libgdal.so.28()(64bit)
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libproj.so.19()(64bit)
   provider: proj70-7.0.1-4.rhel8.x86_64
   provider: proj71-7.1.1-3.rhel8.x86_64
   provider: proj72-7.2.1-1.rhel8.x86_64
  dependency: proj72 >= 7.2.0
   provider: proj72-7.2.1-1.rhel8.x86_64

sudo dnf repoquery --quiet --latest-limit 1 --deplist postgis25_96 | grep 'proj\|gdal'
  dependency: gdal32-libs >= 3.2.2
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libgdal.so.28()(64bit)
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libproj.so.19()(64bit)
   provider: proj70-7.0.1-4.rhel8.x86_64
   provider: proj71-7.1.1-3.rhel8.x86_64
   provider: proj72-7.2.1-1.rhel8.x86_64
  dependency: proj72 >= 7.2.1
   provider: proj72-7.2.1-1.rhel8.x86_64

sudo dnf repoquery --quiet --latest-limit 1 --deplist postgis25_10 | grep 'proj\|gdal'
  dependency: gdal32-libs >= 3.2.2
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libgdal.so.28()(64bit)
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libproj.so.19()(64bit)
   provider: proj70-7.0.1-4.rhel8.x86_64
   provider: proj71-7.1.1-3.rhel8.x86_64
   provider: proj72-7.2.1-1.rhel8.x86_64
  dependency: proj72 >= 7.2.1
   provider: proj72-7.2.1-1.rhel8.x86_64

sudo dnf repoquery --quiet --latest-limit 1 --deplist postgis25_11 | grep 'proj\|gdal'
  dependency: gdal32-libs >= 3.2.2
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libgdal.so.28()(64bit)
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libproj.so.19()(64bit)
   provider: proj70-7.0.1-4.rhel8.x86_64
   provider: proj71-7.1.1-3.rhel8.x86_64
   provider: proj72-7.2.1-1.rhel8.x86_64
  dependency: proj72 >= 7.2.1
   provider: proj72-7.2.1-1.rhel8.x86_64

sudo dnf repoquery --quiet --latest-limit 1 --deplist postgis25_12 | grep 'proj\|gdal'
  dependency: gdal32-libs >= 3.2.2
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libgdal.so.28()(64bit)
   provider: gdal32-libs-3.2.3-1.rhel8.x86_64
  dependency: libproj.so.19()(64bit)
   provider: proj70-7.0.1-4.rhel8.x86_64
   provider: proj71-7.1.1-3.rhel8.x86_64
   provider: proj72-7.2.1-1.rhel8.x86_64
  dependency: proj72 >= 7.2.1
   provider: proj72-7.2.1-1.rhel8.x86_64


On our current CentOS 8 server we have gdal32-libs version 3.2.0 and only proj72 installed, but that version is not available from the repo anymore.

Is there any way I can install a valid gdal32-libs package that uses the same proj72 lib?


Thanks,
Daniel