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> 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> 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
>>
>