RE: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15

Hi Qasim,

Same error as before for “yum update postgresql13-server-13.15 postgresql13-llvmjit-13.15”.
I am on RHEL 9.3 and the LLVM-libs is stuck at 16.0.6. We cannot update it to 17.0.6 and we don’t know why.
We are close to open a support ticket.

On RHEL 9.4, LLVM-libs is at version 17.0.6 and I don’t have the issue to update postgresql13-server and postgresql13-llvmjit to version 13.15.

Regards,

Maxime Dumont

De : Qasim Tahir <qasimtahir(dot)qt1(at)gmail(dot)com>
Envoyé : 10 juillet 2024 01:37
À : Zaid Shabbir <zaidshabbir(at)gmail(dot)com>
Cc : Devrim Gündüz <devrim(at)gunduz(dot)org>; Maxime Dumont <maxime(dot)dumont(at)dti(dot)ulaval(dot)ca>; pgsql-pkg-yum(at)lists(dot)postgresql(dot)org
Objet : Re: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15

Hello,

Please use the below command to update
yum update postgresql13-server-13.15 postgresql13-llvmjit-13.15

This will update postgresql13-server-13.15 smoothly

Regards,
Qasim

On Wed, Jul 10, 2024 at 8:25 AM Zaid Shabbir <zaidshabbir(at)gmail(dot)com<mailto:zaidshabbir(at)gmail(dot)com>> wrote:
Hello Devrim,

Its llvm compatibility issue on RHEL 9. Which RHEL 9 version are you using ?

On Tue, Jul 9, 2024 at 2:56 PM Devrim Gündüz <devrim(at)gunduz(dot)org<mailto:devrim(at)gunduz(dot)org>> wrote:
Hi,

On Thu, 2024-07-04 at 20:36 +0000, Maxime Dumont wrote:
>
>
> I got this error when I try to update Postgresql 13.14 to 13.15 on Red
> Hat 9:
>
> yum update postgresql13-server-13.15
> Updating Subscription Management repositories.
> Last metadata expiration check: 0:22:53 ago on Thu 04 Jul 2024
> 04:11:28 PM EDT.
> Error:
> Problem: problem with installed package postgresql13-llvmjit-13.14-
> 1PGDG.rhel9.x86_64
> - package postgresql13-llvmjit-13.14-1PGDG.rhel9.x86_64 from @System
> requires postgresql13-server(x86-64) = 13.14-1PGDG.rhel9, but none of
> the providers can be installed
> - package postgresql13-llvmjit-13.14-1PGDG.rhel9.x86_64 from pgdg13
> requires postgresql13-server(x86-64) = 13.14-1PGDG.rhel9, but none of
> the providers can be installed
> - cannot install both postgresql13-server-13.15-1PGDG.rhel9.x86_64
> from pgdg13 and postgresql13-server-13.14-1PGDG.rhel9.x86_64 from
> @System
> - cannot install both postgresql13-server-13.15-1PGDG.rhel9.x86_64
> from pgdg13 and postgresql13-server-13.14-1PGDG.rhel9.x86_64 from
> pgdg13
> - cannot install the best update candidate for package postgresql13-
> server-13.14-1PGDG.rhel9.x86_64
> - nothing provides libLLVM-17.so()(64bit) needed by postgresql13-
> llvmjit-13.15-1PGDG.rhel9.x86_64 from pgdg13
> - nothing provides libLLVM-17.so(LLVM_17)(64bit) needed by
> postgresql13-llvmjit-13.15-1PGDG.rhel9.x86_64 from pgdg13
> (try to add '--allowerasing' to command line to replace conflicting
> packages or '--skip-broken' to skip uninstallable packages or '--
> nobest' to use not only best candidate packages)
>
> Can someone make the package postgresql13-llvmjit-13.15-
> 1PGDG.rhel9.x86_64 available on Red Hat 9 please?

Package is available. See the error message. You also need to update
LLVM package to be able to use the latest minor versions.

Regards,

--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR