Problem with postgis 3.1 on RHEL9 - Mailing list pgsql-pkg-yum

From Lorenz, Christopher
Subject Problem with postgis 3.1 on RHEL9
Date
Msg-id 08985bb7661d4412a582fb4a7192bd37@ZIT-BB.Brandenburg.de
Whole thread Raw
List pgsql-pkg-yum
Hello,

while Updating RHEL9 we have problem with the dependencies. Postgis 3.1 is installed with dependency on gdal38-libs,
butthe current gdal38-libs requires libSFCGAL.so.2, but postgis31_13 itself  libSFCGAL.so.1 as I understand. Can anyone
reproducethe 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 requires libSFCGAL.so.1()(64bit), but none of
theproviders can be installed 
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
andSFCGAL-libs-1.5.1-2PGDG.rhel9.x86_64 from @System 
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
andSFCGAL-libs-1.4.1-11.rhel9.x86_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_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
andSFCGAL-libs-1.5.1-2PGDG.rhel9.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_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 and
SFCGAL-1.5.0-1.el9.x86_64from ZIT-BB_Extra_Packages_for_Enterprise_Linux_EPEL_-_RHEL_9_x86_64 
  - cannot install the best update candidate for package postgis31_13-3.1.11-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_PostgreSQL13_-_RHEL_9_x86_64 requires
libSFCGAL.so.1()(64bit),but none of the providers can be installed 
  - package postgis31_13-3.1.11-3PGDG.rhel9.x86_64 from @System requires libSFCGAL.so.1()(64bit), but none of the
providerscan be installed 
  - cannot install both SFCGAL-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 and
SFCGAL-1.5.0-1.el9.x86_64from ZIT-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-libs(x86-64) = 1.5.1-2PGDG.rhel9, but none of
theproviders can be installed 
  - package SFCGAL-1.5.1-2PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64 requires
SFCGAL-libs(x86-64)= 1.5.1-2PGDG.rhel9, but none of the providers can be installed 
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
andSFCGAL-libs-1.5.1-2PGDG.rhel9.x86_64 from @System 
  - cannot install both SFCGAL-libs-2.0.0-1PGDG.rhel9.x86_64 from ZIT-BB_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
andSFCGAL-libs-1.4.1-11.rhel9.x86_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_PostgreSQL_PostgreSQL-common_-_RHEL_9_x86_64
andSFCGAL-libs-1.5.1-2PGDG.rhel9.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_PostgreSQL-common_-_RHEL_9_x86_64 requires
libSFCGAL.so.2()(64bit),but none of 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ügen, um Pakete mit Konflikten zu ersetzen or '--skip-broken'
toskip uninstallable packages 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



pgsql-pkg-yum by date:

Previous
From: Chuan Hua Zhao
Date:
Subject: pgbouncer and pgbackrest rpm on ppc64le
Next
From: Cameron Murdoch
Date:
Subject: LLVM 18.1.8 missing from pgdg-centos8-sysupdates?