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 1soIKu-00A1Ws-8t for pgsql-admin@arkaria.postgresql.org; Wed, 11 Sep 2024 08:04:25 +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 1soIKt-00BVgn-Qc for pgsql-admin@arkaria.postgresql.org; Wed, 11 Sep 2024 08:04:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1soIKt-00BVge-Av for pgsql-admin@lists.postgresql.org; Wed, 11 Sep 2024 08:04:23 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1soIKq-000b5u-Go for pgsql-admin@lists.postgresql.org; Wed, 11 Sep 2024 08:04:22 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-a90188ae58eso14322566b.1 for ; Wed, 11 Sep 2024 01:04:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726041859; x=1726646659; 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=im0r4Dr9q61A8rj2CM73AZtjP0hLsa5+rHmeYSTGm6Y=; b=MEjyGCNKn1bq8xQBKi24zqU1LuHV9wLtoPuv+FJvB3XgHCIgXUdd5IY2+K0LN+JgXA GxnfITdWDaxpV9kUMZoUVIj4uucBfsl0jpacK1NCdvSYWocVv0mZxfEfH6VGjCF3h5Ga xtJOgpSYtnuHemx1TyhMGms7akGLpUsXSrYLwySMhKLAjD94QDKchQkvCf1XTRjRKeER QBCmao6QbwnndpklBqlm/W7NcikMGvF/78W2UtIYAwNrNs5HmSpc5ajc/a99KK+ya5bP A/MQEUYEbrW1wP1aRDOKqmvtYQajtXN6skxaORUpOq06I1MQijaETjIMWjFsFfe3ehna CuMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726041859; x=1726646659; 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=im0r4Dr9q61A8rj2CM73AZtjP0hLsa5+rHmeYSTGm6Y=; b=dt0SUPMgVrikz6ezM4eXrYKifa7KWqIRqGWUUorl6Gp+KGsT8+Qjqp6kwz/BC7fmLh 3X4E3cmUs9HoPYv63muFmQlHSMkichK7OE3FwMMxrSOVqU+/VRYVAL183ftsq3xUcktF B+xlb1ng9yD2wTmzU7xFNrt17BlQgiMJDENaMD71XQGv03p3XRRltTuUQVQU/BQ6vZh9 Yorp92x6IGCDtqIYhsblFtSofFw1M9UneKe/MM0Hog5sooGjS/zvin5tMy2ZHxDctxTu 6rv1tKAkGRJLTU5GhBFuufWtNtZZxRQ3VjkP0T1bhxMQXzy5Qqx7CHnA98Cfv/032wAu or1Q== X-Gm-Message-State: AOJu0YzayDOetjoSL3Npq4IB7KDxFXgF0h3hS3NnUMv2K6/AdIh3p2/h 9o7YtXayCDLPI1kohHHDcFqwCeZGvE/2F2wDwLgT2gcf/Z4XDze+ZwY1sUI9U3fMnkQhPXmn98M PnvTdO2MiaCj6kG1oOm/xHXigYqw= X-Google-Smtp-Source: AGHT+IE1ujnfz2K3JS/aAOELPJDT/UfEP6BuAvMKiJOWqcF14oWQ/Oute9yiiU3tXaGgo2qroWJqcGTaNdOrIQAPMhE= X-Received: by 2002:a17:907:968e:b0:a86:a013:2161 with SMTP id a640c23a62f3a-a8ffab84449mr289488166b.30.1726041858667; Wed, 11 Sep 2024 01:04:18 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Asad Ali Date: Wed, 11 Sep 2024 13:04:06 +0500 Message-ID: Subject: Re: I'm trying to update postgres from 15.5 to 15.8. Got this error. To: =?UTF-8?Q?P=C3=A4r_Mattsson?= Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000da7b760621d36f76" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000da7b760621d36f76 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi P=C3=A4r Mattsson, The error message indicates a problem with the GPG signature verification for the repository metadata, which is preventing the yum or dnf package manager from updating PostgreSQL. Run the following commands to clear the DNF cache and rebuild it: sudo dnf clean all sudo dnf makecache The GPG signature verification error could be caused by a missing or corrupted GPG key for the PostgreSQL repository. You can manually download and install the key. sudo rpm --import https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG Verify the key has been installed. rpm -qi gpg-pubkey | grep -i "PostgreSQL" After ensuring the GPG key is correctly installed, try updating PostgreSQL again. sudo yum update postgresql* or sudo dnf update postgresql* Best Regards, Asad Ali On Wed, Sep 11, 2024 at 12:18=E2=80=AFPM P=C3=A4r Mattsson wrote: > > > > *Fr=C3=A5n:* P=C3=A4r Mattsson > *Skickat:* den 11 september 2024 09:13 > *Till:* Pgsql-admin > *=C3=84mne:* I'm trying to update postgres from 15.5 to 15.8. Got this er= ror. > > > > [root@localhost]# yum update postgresql > > Updating Subscription Management repositories. > > PostgreSQL common RPMs for RHEL / Rocky 8 - > x86_64 > 2.0 kB/s | 659 B 00:00 > > PostgreSQL common RPMs for RHEL / Rocky 8 - > x86_64 > 1.6 MB/s | 1.7 kB 00:00 > > PostgreSQL common RPMs for RHEL / Rocky 8 - > x86_64 > 1.0 kB/s | 659 B 00:00 > > *Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GP= G > signature verification error: Bad GPG signature* > > > > > > [root@vidi-db02 ~]# dnf list installed | grep postgres > > postgresql15.x86_64 > 15.5-1PGDG.rhel8 @pgdg15 > > postgresql15-libs.x86_64 > 15.5-1PGDG.rhel8 @pgdg15 > > postgresql15-server.x86_64 > 15.5-1PGDG.rhel8 @pgdg15 > > > > Br P=C3=A4r Mattsson > --000000000000da7b760621d36f76 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0 P=C3=A4r= Mattsson,

The error message indicates a problem w= ith the GPG signature verification for the repository metadata, which is pr= eventing the yum or dnf package manager from updating PostgreSQL.

Run the following commands to clear the DNF cache and rebui= ld it:
sudo dnf clean all
sudo dnf makecache
=
The GPG signature verification error could be caused by a mi= ssing or corrupted GPG key for the PostgreSQL repository. You can manually = download and install the key.

<= div>Verify the key has been installed.
rpm -qi gpg-pubkey | g= rep -i "PostgreSQL"

After ensuring t= he GPG key is correctly installed, try updating PostgreSQL again.
sudo= yum update postgresql*
or
sudo dnf update postgresql*

Best Regards,
Asad Ali

On Wed, Sep 11, 2024 at 12:18=E2=80=AFPM= P=C3=A4r Mattsson <par.x.ma= ttsson@gmail.com> wrote:

=C2=A0

Fr=C3=A5n: P=C3=A4r Mattsson
Skickat: den 11 september 2024 09:13
Till: Pgsql-admin <pgsql-admin@lists.postgresql.org>
=C3=84mne: I'm trying to update postgres from 15.5 to 15.8. Got = this error.

=C2=A0

[root@localhost]# yum update postgresql

Updating Subscription Management repositories.<= /p>

PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 2.0 kB/s | 659=C2=A0 B=C2=A0=C2=A0=C2=A0=C2=A0 00:00

PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 1.6 MB/s | 1.7 kB=C2=A0=C2=A0=C2=A0=C2=A0 00:00

PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 1.0 kB/s | 659=C2=A0 B=C2=A0=C2=A0=C2=A0=C2=A0 00:00

Error: Failed to download metadata for repo 'pg= dg-common': repomd.xml GPG signature verification error: Bad GPG signat= ure

=C2=A0

=C2=A0

[root@vidi-db02 ~]# dnf list installed | grep postgres=

postgresql15.x86_64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 15.5-1PGDG.rhel8=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 @pgdg15<= /span>

postgresql15-libs.x86_64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 15.5-1PGDG.rhel8=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 @pgdg15

postgresql15-server.x86_64=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 15.5-1PG= DG.rhel8=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 @pgdg15

=C2=A0

Br P=C3=A4r Mattsson

--000000000000da7b760621d36f76--