Postgres Pro
Downloads
Home   >   mailing lists

Re: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15 - Mailing list pgsql-pkg-yum

From Qasim Tahir
Subject Re: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15
Date
Msg-id CAG=GPUMdgwMjyBK4zht99dYKTnqoGmThiOPG4kLO9665TUjN7w@mail.gmail.com
Whole thread Raw
In response to RE: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15  (Maxime Dumont <maxime.dumont@dti.ulaval.ca>)
Responses RE: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15
List pgsql-pkg-yum
Tree view
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.dumont@dti.ulaval.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.qt1@gmail.com>
Envoyé : 10 juillet 2024 01:37
À : Zaid Shabbir <zaidshabbir@gmail.com>
Cc : Devrim Gündüz <devrim@gunduz.org>; Maxime Dumont <maxime.dumont@dti.ulaval.ca>; pgsql-pkg-yum@lists.postgresql.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@gmail.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@gunduz.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

pgsql-pkg-yum by date:

Previous
From: Maxime Dumont
Date:
Subject: RE: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15
Next
From: Maxime Dumont
Date:
Subject: RE: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15