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

Hi,

Our servers use subscription-manager and it was stuck at release 9.3 and LLVM version 17 was not available.

With the commands “subscription-manager release --unset" and a “dnf update” I was now able to upgrade to RHEL version 9.4 and LLVM has been upgraded to 17.0.6 as expected.

Now I can update the packages postgresql13-server and postgresql13-llvmjit to version 13.15 without any problem.

Thank you all

Maxime Dumont

De : Qasim Tahir <qasimtahir(dot)qt1(at)gmail(dot)com>
Envoyé : 12 juillet 2024 03:01
À : Maxime Dumont <maxime(dot)dumont(at)dti(dot)ulaval(dot)ca>
Cc : Zaid Shabbir <zaidshabbir(at)gmail(dot)com>; Devrim Gündüz <devrim(at)gunduz(dot)org>; 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

Hi,

I am unable to reproduce the issue at my end on RHEL 9.3

It seems to me that your rhel 9.3 is unable to update through repo
I can tell you some troubleshooting attempts that you can do
1. Check that your repo on rhel 9.3 is able to connect and it points to the latest version
2. Check that your pgdg repo is configured properly and able to get updates from repo. you can run below command to perform

sudo rpm -Uvh https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

sudo yum update postgresql13-server-13.15 postgresql13-llvmjit-13.15

This will update LLVM-libs to 17.0.6 version also and will update postgresql13-server to 13.15

Regards

Qasim

On Wed, Jul 10, 2024 at 5:24 PM Maxime Dumont <maxime(dot)dumont(at)dti(dot)ulaval(dot)ca<mailto:maxime(dot)dumont(at)dti(dot)ulaval(dot)ca>> wrote:
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<mailto:qasimtahir(dot)qt1(at)gmail(dot)com>>
Envoyé : 10 juillet 2024 01:37
À : Zaid Shabbir <zaidshabbir(at)gmail(dot)com<mailto:zaidshabbir(at)gmail(dot)com>>
Cc : Devrim Gündüz <devrim(at)gunduz(dot)org<mailto:devrim(at)gunduz(dot)org>>; Maxime Dumont <maxime(dot)dumont(at)dti(dot)ulaval(dot)ca<mailto:maxime(dot)dumont(at)dti(dot)ulaval(dot)ca>>; pgsql-pkg-yum(at)lists(dot)postgresql(dot)org<mailto: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