Re: BUG #18013: Failed installing - Mailing list pgsql-bugs

From otheus uibk
Subject Re: BUG #18013: Failed installing
Date
Msg-id CALbQNd1HUsFvVw0bG_kDhHJQ=MP1_N1eH1t6JaKHKNqyc7LbTA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18013: Failed installing  (otheus uibk <otheus.uibk@gmail.com>)
List pgsql-bugs
Sorry, I guess the previous email should have been directed to pgsql-pkg-yum . 

On Sun, Aug 13, 2023 at 9:15 PM otheus uibk <otheus.uibk@gmail.com> wrote:
[[ Bump ]]

Thanks Yubing for letting me know it's not just me. 

The key appears to be more than 2 years old. Are we perhaps the only 2 to have this problem since April??

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@postgresql.org>
Summary     : PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.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@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18013
Logged by:          Yubing Lin
Email address:      yul201@ucsd.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



--


--

pgsql-bugs by date:

Previous
From: otheus uibk
Date:
Subject: Re: BUG #18013: Failed installing
Next
From: Michael Paquier
Date:
Subject: Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon