Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sSAHi-004iB2-H0 for pgsql-pkg-yum@arkaria.postgresql.org; Fri, 12 Jul 2024 07:01:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sSAHg-005f5w-UF for pgsql-pkg-yum@arkaria.postgresql.org; Fri, 12 Jul 2024 07:01:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sSAHg-005f5o-KX for pgsql-pkg-yum@lists.postgresql.org; Fri, 12 Jul 2024 07:01:36 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sSAHd-001gYN-Ot for pgsql-pkg-yum@lists.postgresql.org; Fri, 12 Jul 2024 07:01:36 +0000 Received: by mail-wm1-x334.google.com with SMTP id 5b1f17b1804b1-42797bcfc77so11288455e9.2 for ; Fri, 12 Jul 2024 00:01:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720767692; x=1721372492; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=4PS9Fz+FN/32HXbbNHdeISx7H6kax+grrSTU62S2FXk=; b=ZSt426s+xWEoWG+lzyaz5cZLy2BcRIIsd4GO7XGtaLNGzQ0W5HBR2Tje6eop2ci6hN A9N2cDpMkzhDWisnaY1tdX7MTD47ubmb3pGjnwnGPINh7uaWnQYSwdrBY/aW+WS4RG5A frv6d+hoOX85vexrMAL4o2weKuSMqmCQHpRNBcD8lj9IXe8IIh3mb9YfVOuhnrs8kFi7 jEQkoMO/0xJSgpO0jKN/cCFa3SRUiC1CScz28gXx0NgkuawKD0PJ4jC2myUS9F6tFyrB 3eTNeNZrc8jpLldOFsr1aHqAZ1nl847n6mg+16/7HXuvJSOkF3nILzMWNxK4X+zMLSdD HQ0g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720767692; x=1721372492; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=4PS9Fz+FN/32HXbbNHdeISx7H6kax+grrSTU62S2FXk=; b=UhYaTW/0XBt7Zk82ppXP8BN4oYOhroEci4m7VkEFmrCkHEkl6EbyyJsXFbOvl0o+sm Xu558Q8ELkICK3A4jAj1BsyU6a3vY/UFVqQoZVaLwVswAq4Z4ROyiEmjYBpmjA8pm6iJ rtz8WfxrZyG9ezDkK3coNPSASm5LPYVPOaXT9EoG+SI/amyts55+s8IOh9V6fbVWFsOo vHN5aOW+DGLWoPOc1wQFFGQcdIWy4Ix6mSEnaNHs9M4c3VXFNUsUk6EgGHJ//KIZk3rZ bqN/7aS8x5ETDRs8kPLv3oQAUdu9O7dW7K6opLno/rTHdl/GCZ08JWs8HKOs5NdbA1WL npaA== X-Forwarded-Encrypted: i=1; AJvYcCUdJ2nKdkMkJoQ8+NqwPdxtC6ONNcCz10YVu3DI6Lkj5aT/0pN1Ih0kcUg0kMaoLLG+dkiTz08BTLbmi8dRY3iO/8sqVepZX5DIm5jK3pEQTyeZ X-Gm-Message-State: AOJu0Yz7jLwDY/m3XUUyHF0W9q53J0YRuKX1aa8AJpWkUIhGlsqAC5mN v6dR12E4nyTJOq8GiDm9jzQrp9aIncSB8eDhd6dZVN8qtGtpw25cNqvta0vXMdBmZtBtBztXDmY d9tKy2lK9e88315dp6/MGMXEUqRg= X-Google-Smtp-Source: AGHT+IH2m802Svv1NLjH8FZ4WKbOkBA9hpK9Yy8WeDfAEz+SA5HbWbu3YQwejQgun/GI+e9vtyNP/OwUteLxhi3lfoM= X-Received: by 2002:adf:f704:0:b0:367:8a87:ada2 with SMTP id ffacd0b85a97d-367cea73311mr6980443f8f.26.1720767692233; Fri, 12 Jul 2024 00:01:32 -0700 (PDT) MIME-Version: 1.0 References: <9ebe2124a916a0e4f4a0d1e9d7dba704251dadc2.camel@gunduz.org> In-Reply-To: From: Qasim Tahir Date: Fri, 12 Jul 2024 12:01:20 +0500 Message-ID: Subject: Re: Red Hat Enterprise Linux 9 error with LLVM (needed by JIT) for postgresql 13.15 To: Maxime Dumont Cc: Zaid Shabbir , =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= , "pgsql-pkg-yum@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000000961e0061d0773ad" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000961e0061d0773ad Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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-x= 86_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=E2=80=AFPM Maxime Dumont wrote: > Hi Qasim, > > > > Same error as before for =E2=80=9Cyum update postgresql13-server-13.15 > postgresql13-llvmjit-13.15=E2=80=9D. > > I am on RHEL 9.3 and the LLVM-libs is stuck at 16.0.6. We cannot update i= t > to 17.0.6 and we don=E2=80=99t 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=E2=80=99t have the = issue to > update postgresql13-server and postgresql13-llvmjit to version 13.15. > > > > Regards, > > > > *Maxime Dumont* > > > > *De :* Qasim Tahir > *Envoy=C3=A9 :* 10 juillet 2024 01:37 > *=C3=80 :* Zaid Shabbir > *Cc :* Devrim G=C3=BCnd=C3=BCz ; 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=E2=80=AFAM Zaid Shabbir > wrote: > > Hello Devrim, > > > > Its llvm compatibility issue on RHEL 9. Which RHEL 9 version are you usin= g > ? > > > > On Tue, Jul 9, 2024 at 2:56=E2=80=AFPM Devrim G=C3=BCnd=C3=BCz 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) =3D 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) =3D 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=C3=BCnd=C3=BCz > Open Source Solution Architect, PostgreSQL Major Contributor > Twitter: @DevrimGunduz , @DevrimGunduzTR > > --0000000000000961e0061d0773ad Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

I am unable to reproduce the issue at my end on RH= EL 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 th= at your=C2=A0repo on rhel 9.3 is able to connect and it points to the lates= t=C2=A0version=C2=A0
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://downlo=
ad.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-lates=
t.noarch.rpm

sudo yum update postgresql13-server-13.15 postgresql13-llvmjit-13.1=
5
 
This will update=C2=A0LLVM-libs=C2=A0to 17.0.=
6 version also and will update postgresql13-server to 13.15
Regards
Qasim=C2=A0<=
/pre>

On Wed, Jul 10, 2024 at 5:24=E2=80=AFPM Maxime Dumont <<= a href=3D"mailto:maxime.dumont@dti.ulaval.ca">maxime.dumont@dti.ulaval.ca> wrote:

Hi Qas= im,

=C2=A0

Same e= rror as before for =E2=80=9Cyum update postgresql13-server-13.15 postgresql= 13-llvmjit-13.15=E2=80=9D.

I am o= n RHEL 9.3 and the LLVM-libs is stuck at 16.0.6. We cannot update it to 17.= 0.6 and we don=E2=80=99t know why.

We are= close to open a support ticket.

=C2=A0

On RHE= L 9.4, LLVM-libs is at version 17.0.6 and I don=E2=80=99t have the issue to= update postgresql13-server and postgresql13-llvmjit to version 13.15.

=C2=A0

Regard= s,

=C2=A0

Maxime Dumont

=C2=A0<= /span>

De=C2=A0: Qasim Tahir <qasimtahir.qt1@gmail.com>
Envoy=C3=A9=C2=A0: 10 juillet 2024 01:37
=C3=80=C2=A0: Zaid Shabbir <zaidshabbir@gmail.com>
Cc=C2=A0: Devrim G=C3=BCnd=C3=BCz <devrim@gunduz.org>; Maxime Dumont <maxime.dumont@d= ti.ulaval.ca>; pgsql-pkg-yum@lists.postgresql.org
Objet=C2=A0: Re: Red Hat Enterprise Linux 9 error with LLVM (needed = by JIT) for postgresql 13.15

=C2=A0

Hello,

Please use the below command to update

yum update postgresql13-server-13.15=C2=A0postgresql= 13-llvmjit-13.15

This will update postgresql13-server-13.15 smoothly

Regards,
Qasim

=C2=A0

On Wed, Jul 10, 2024 at 8:25=E2=80=AFAM Zaid Shabbir <zaidshabbir@gmail.com> wrot= e:

Hello=C2=A0Devrim,

=C2=A0

Its llvm compatibility=C2=A0issue on RHEL 9. Which R= HEL 9 version are you using ?

=C2=A0

On Tue, Jul 9, 2024 at 2:56=E2=80=AFPM Devrim G=C3=BCnd=C3=BCz <devrim@gunduz.org> w= rote:

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
> =C2=A0 - package postgresql13-llvmjit-13.14-1PGDG.rhel9.x86_64 from @S= ystem
> requires postgresql13-server(x86-64) =3D 13.14-1PGDG.rhel9, but none o= f
> the providers can be installed
> =C2=A0 - package postgresql13-llvmjit-13.14-1PGDG.rhel9.x86_64 from pg= dg13
> requires postgresql13-server(x86-64) =3D 13.14-1PGDG.rhel9, but none o= f
> the providers can be installed
> =C2=A0 - cannot install both postgresql13-server-13.15-1PGDG.rhel9.x86= _64
> from pgdg13 and postgresql13-server-13.14-1PGDG.rhel9.x86_64 from
> @System
> =C2=A0 - cannot install both postgresql13-server-13.15-1PGDG.rhel9.x86= _64
> from pgdg13 and postgresql13-server-13.14-1PGDG.rhel9.x86_64 from
> pgdg13
> =C2=A0 - cannot install the best update candidate for package postgres= ql13-
> server-13.14-1PGDG.rhel9.x86_64
> =C2=A0 - nothing provides libLLVM-17.so()(64bit) needed by postgresql1= 3-
> llvmjit-13.15-1PGDG.rhel9.x86_64 from pgdg13
> =C2=A0 - 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 confli= cting
> 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=C3=BCnd=C3=BCz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR

--0000000000000961e0061d0773ad--