gpg error (again)

Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG
signature verification error: Bad GPG signature

OS: Rocky9, minimal installation:

# dnf -y install
https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Last metadata expiration check: 0:27:25 ago on Sun Aug 13 18:39:50 2023.
pgdg-redhat-repo-latest.noarch.rpm
11 kB/s | 11 kB 00:00
Dependencies resolved.
=================================================================================================================================
Package Architecture Version
Repository Size
=================================================================================================================================
Installing:
pgdg-redhat-repo noarch 42.0-32
@commandline 11 k

Transaction Summary
=================================================================================================================================
Install 1 Package

Total size: 11 k
Installed size: 14 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing :
1/1
Installing : pgdg-redhat-repo-42.0-32.noarch
1/1
Verifying : pgdg-redhat-repo-42.0-32.noarch
1/1

Installed:
pgdg-redhat-repo-42.0-32.noarch

Complete!
bash-5.1# dnf -y install postgresql14-server
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
1.1 kB/s | 833 B 00:00
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
1.6 MB/s | 1.7 kB 00:00
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
1.0 kB/s | 833 B 00:00
Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG
signature verification error: Bad GPG signature
bash-5.1# dnf -y install postgresql15-server
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
832 B/s | 833 B 00:01
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
1.6 MB/s | 1.7 kB 00:00
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
1.1 kB/s | 833 B 00:00
Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG
signature verification error: Bad GPG signature

# sha256sum /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
991821e20c4af66314b023db867c7ee8d593f249b9732cbacba7bcd7b25e9604
/etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG

Name : gpg-pubkey
Version : 442df0f8
Release : 608c8351
Architecture: (none)
Install Date: Sun Aug 13 18:59:35 2023
Group : Public Keys
Size : 0
License : pubkey
Signature : (none)
Source RPM : (none)
Build Date : Fri Apr 30 22:23:13 2021
Build Host : localhost
Packager : PostgreSQL RPM Building Project <pgsql-pkg-yum(at)postgresql(dot)org>
Summary : PostgreSQL RPM Building Project <pgsql-pkg-yum(at)postgresql(dot)org>
public key
Description :
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: rpm-4.16.1.3 (NSS-3)

mQGiBEeD8koRBACC1VBRsUwGr9gxFFRho9kZpdRUjBJoPhkeOTvp9LzkdAQMFngr
BFi6N0ov1kCX7LLwBmDG+JPR7N+XcH9YR1coSHpLVg+JNy2kFDd4zAyWxJafjZ3a
9zFg9Yx+0va1BJ2t4zVcmKS4aOfbgQ5KwIOWUujalQW5Y+Fw39Gn86qjbwCg5dIo
tkM0l19h2sx50D027pV5aPsD/2c9pfcFTbMhB0CcKS836GH1qY+NCAdUwPs646ee
Ex/k9Uy4qMwhl3HuCGGGa+N6Plyon7V0TzZuRGp/1742dE8IO+I/KLy2L1d1Fxrn
XOTBZd8qe6nBwh12OMcKrsPBVBxn+iSkaG3ULsgOtx+HHLfa1/p22L5+GzGdxizr
peBuA/90cCp+lYcEwdYaRoFVR501yDOTmmzBc1DrsyWP79QMEGzMqa393G0VnqXt
L4pGmunq66Agw2EhPcIt3pDYiCmEt/obdVtSJH6BtmSDB/zYhbE8u3vLP3jfFDa9
KXxgtYj0NvuUVoRmxSKm8jtfmj1L7zoKNz3jl+Ba3L0WxIv4+bQ+UG9zdGdyZVNR
TCBSUE0gQnVpbGRpbmcgUHJvamVjdCA8cGdzcWwtcGtnLXl1bUBwb3N0Z3Jlc3Fs
Lm9yZz6IeAQTEQIAOBYhBGjJ4rkaN9E2/nTRdh8W0uFELfD4BQJgjINRAhsjBQsJ
CAcCBhUKCQgLAgQWAgMBAh4BAheAAAoJEB8W0uFELfD4/LIAoMfDXiSSVZ3dcPAY
PU2/k0MrqrZhAJsHOI13LWuNiTf5qMZE6Znoi5sxibkCDQRHg/JKEAgA64+ZXgcE
RPYfZYo4p+yMTJAAa9aqnE3U4Ni6ZMB57GPuEy8NfbNya+HiftO8hoozmJdcI6XF
yRBCDUVCdZ8SE+PJdOx2FFqZVIu6dKnr8ykhgLpNNEFDG3boK9UfLj/5lYQ3Y550
Iym1QKOgyrJYeAp6sZ+Nx2PavsP3nMFCSD67BqAbcLCVQN7a2dAUXfEbfXJjPHXT
bo1/kxtzE+KCRTLdXEbSEe3nHO04K/EgTBjeBUOxnciH5RylJ2oGy/v4xr9ed7R1
jJtshsDKMdWApwoLlCBJ63jg/4T/z/OtXmu4AvmWaJxaTl7fPf2GqSqqb6jLCrQA
H7AIhXr9V0zPZwADBQgAlpptNQHlu7euIdIujFwwcxyQGfee6BG+3zaNSEHMVQMu
c6bxuvYmgM9r7aki/b0YMfjJBk8vOJ3Eh1vDH/woJi2iJ13vQ21ot+1JP3fMd6NP
R8/qEeDnmVXu7QAtlkmSKI9RdnjzFFSUJrQPHnKsH4V4uvAM+njwYD+VFiwlBPTK
NeL8cdBb4tPN2cdVJzoAp57wkZANVA2tKxNsTJKBi8wukaLWX8+yPHiWCNWItvyB
4WCEp/rZKG4A868NM5sZQMAabpLdl4fTiGu68OYgK9qUPZvhEAL2C1jPDVHPkLm+
ZsD+90Pe66w9vB00cxXuHLzm8PadGaCXCY8h3xi6VIhJBBgRAgAJBQJHg/JKAhsM
AAoJEB8W0uFELfD4K4cAoJ4yug8y1U0cZEiF5W25HDzMTtaDAKCaM1m3Cbd+AZ0N
GWNg/VvIX9MsPA==
=ZSdS
-----END PGP PUBLIC KEY BLOCK-----

dnf config-manager --set-disabled "pgdg*"
bash-5.1# dnf config-manager --set-enabled "pgdg-common" --set-enabled
pgdg12
bash-5.1# dnf -y install postgresql12-server
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
1.1 kB/s | 833 B 00:00
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
1.6 MB/s | 1.7 kB 00:00
PostgreSQL common RPMs for RHEL / Rocky 9 - aarch64
486 B/s | 833 B 00:01
Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG
signature verification error: Bad GPG signature

On Mon, Jul 3, 2023 at 12:56 PM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 18013
> Logged by: Yubing Lin
> Email address: yul201(at)ucsd(dot)edu
> PostgreSQL version: 16beta2
> Operating system: CentOS 7
> Description:
>
> I downloaded the latest version by yum install -y
>
> https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> and then tried to install by yum install -y postgresql16-server but
> encounter the error of [Error -1] repomd.xml signature could not be
> verified
> for pgdg-common
>
>

--
Otheus
otheus(dot)uibk(at)gmail(dot)com
otheus(dot)shelling(at)uibk(dot)ac(dot)at

--
Otheus
otheus(dot)uibk(at)gmail(dot)com
otheus(dot)shelling(at)uibk(dot)ac(dot)at