Invalid PostGIS 2.4 and 2.5 packages

From: Daniel Beland <dcendents(at)gmail(dot)com>
To: pgsql-pkg-yum(at)lists(dot)postgresql(dot)org
Subject: Invalid PostGIS 2.4 and 2.5 packages
Date: 2021-12-16 16:23:47
Message-ID: CACbYwvoAonwozj+y7dDO_JnR0K93iyv+eprkj8cdm0cKMJ9tNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum

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

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Matti Linnanvuori 2021-12-17 06:08:08 Package postgis32_14-docs-3.2.0-rc1.rhel7.x86_64.rpm is not signed
Previous Message Devrim Gündüz 2021-12-09 17:41:58 Re: Installing plv89 extension to Postgres 13