public inbox for [email protected]  
help / color / mirror / Atom feed
From: Asad Ali <[email protected]>
To: Pär Mattsson <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: I'm trying to update postgres from 15.5 to 15.8. Got this error.
Date: Wed, 11 Sep 2024 13:04:06 +0500
Message-ID: <CAJ9xe=vT4OteJ-KrpMKO7Sv3Pzb7s=8TcdLkcjmUg0WfjaHN3Q@mail.gmail.com> (raw)
In-Reply-To: <AM6PR03MB5558C72F3AF22596BC157863A29B2@AM6PR03MB5558.eurprd03.prod.outlook.com>
References: <OLAP279MB0007E6469691C0B576B86EF3999B2@OLAP279MB0007.NORP279.PROD.OUTLOOK.COM>
	<OLAP279MB00074ABBCEBCFC7186D51E13999B2@OLAP279MB0007.NORP279.PROD.OUTLOOK.COM>
	<AM6PR03MB5558C72F3AF22596BC157863A29B2@AM6PR03MB5558.eurprd03.prod.outlook.com>

Hi  Pär 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 PM Pär Mattsson <[email protected]>
wrote:

>
>
>
> *Från:* Pär Mattsson
> *Skickat:* den 11 september 2024 09:13
> *Till:* Pgsql-admin <[email protected]>
> *Ämne:* I'm trying to update postgres from 15.5 to 15.8. Got this error.
>
>
>
> [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 GPG
> 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är Mattsson
>


view thread (3+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: I'm trying to update postgres from 15.5 to 15.8. Got this error.
  In-Reply-To: <CAJ9xe=vT4OteJ-KrpMKO7Sv3Pzb7s=8TcdLkcjmUg0WfjaHN3Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox