From: "Lorenz, Christopher" <Christopher.Lorenz@ZIT-BB.Brandenburg.de>
To: "'pgsql-pkg-yum@lists.postgresql.org'"
	<pgsql-pkg-yum@lists.postgresql.org>
Subject: Problem with postgis 3.1 on RHEL9
Thread-Topic: Problem with postgis 3.1 on RHEL9
Thread-Index: AdtEoy2rDjqgWNQKQeqoZgXcwmQLLA==
Date: Mon, 2 Dec 2024 10:15:58 +0000
Message-ID: <08985bb7661d4412a582fb4a7192bd37@ZIT-BB.Brandenburg.de>
Accept-Language: de-DE, en-US
Content-Language: de-DE
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/08985bb7661d4412a582fb4a7192bd37%40ZIT-BB.Brandenburg.de>
Precedence: bulk

Hello,

while Updating RHEL9 we have problem with the dependencies. Postgis 3.1 is =
installed with dependency on gdal38-libs, but the current gdal38-libs requi=
res libSFCGAL.so.2, but postgis31_13 itself  libSFCGAL.so.1 as I understand=
. Can anyone reproduce the problem? Is there a need to compile postgis 3.1 =
against libSFCGAL.so.2?

Result while try to update our system:

 Problem 1: package postgis31_13-3.1.11-3PGDG.rhel9.x86_64 from @System req=
uires libSFCGAL.so.1()(64bit), but none of the providers can be installed
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_Po=
stgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 and SFCGAL-libs-1.5.1-2PGDG.rhel=
9.x86_64 from @System
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_Po=
stgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 and SFCGAL-libs-1.4.1-11.rhel9.x=
86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_Po=
stgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 and SFCGAL-libs-1.5.1-2PGDG.rhel=
9.x86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
  - cannot install both SFCGAL-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_Postgre=
SQL_PostgreSQL-common_-_RHEL_9_x86_64 and SFCGAL-1.5.0-1.el9.x86_64 from ZI=
T-BB_Extra_Packages_for_Enterprise_Linux_EPEL_-_RHEL_9_x86_64
  - cannot install the best update candidate for package postgis31_13-3.1.1=
1-3PGDG.rhel9.x86_64
  - cannot install the best update candidate for package SFCGAL-libs-1.5.1-=
2PGDG.rhel9.x86_64
  - cannot install the best update candidate for package SFCGAL-1.5.1-2PGDG=
.rhel9.x86_64

 Problem 2: Problem mit installiertem Paket postgis31_13-3.1.11-3PGDG.rhel9=
.x86_64
  - package postgis31_13-3.1.11-3PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_P=
ostgreSQL13_-_RHEL_9_x86_64 requires libSFCGAL.so.1()(64bit), but none of t=
he providers can be installed
  - package postgis31_13-3.1.11-3PGDG.rhel9.x86_64 from @System requires li=
bSFCGAL.so.1()(64bit), but none of the providers can be installed
  - cannot install both SFCGAL-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_Postgre=
SQL_PostgreSQL-common_-_RHEL_9_x86_64 and SFCGAL-1.5.0-1.el9.x86_64 from ZI=
T-BB_Extra_Packages_for_Enterprise_Linux_EPEL_-_RHEL_9_x86_64
  - Problem mit installiertem Paket SFCGAL-1.5.1-2PGDG.rhel9.x86_64
  - package SFCGAL-1.5.1-2PGDG.rhel9.x86_64 from @System requires SFCGAL-li=
bs(x86-64) =3D 1.5.1-2PGDG.rhel9, but none of the providers can be installe=
d
  - package SFCGAL-1.5.1-2PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_PostgreS=
QL-common_-_RHEL_9_x86_64 requires SFCGAL-libs(x86-64) =3D 1.5.1-2PGDG.rhel=
9, but none of the providers can be installed
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_Po=
stgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 and SFCGAL-libs-1.5.1-2PGDG.rhel=
9.x86_64 from @System
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_Po=
stgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 and SFCGAL-libs-1.4.1-11.rhel9.x=
86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_Po=
stgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 and SFCGAL-libs-1.5.1-2PGDG.rhel=
9.x86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
  - package gdal38-libs-3.8.5-5PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_Pos=
tgreSQL-common_-_RHEL_9_x86_64 requires libSFCGAL.so.2()(64bit), but none o=
f the providers can be installed
  - cannot install the best update candidate for package gdal38-libs-3.8.5-=
3PGDG.rhel9.x86_64
(Versuchen Sie '--allowerasing' zur Befehlszeile hinzuzuf=FCgen, um Pakete =
mit Konflikten zu ersetzen or '--skip-broken' to skip uninstallable package=
s or '--nobest' to use not only best candidate packages)

May there are more affected combination, I also have trouble with postgis 3=
.2 and PostgreSQL 15 on RHEL9.

Best Regards,

Christopher Lorenz