Re: BUG #18013: Failed installing

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(dot)uibk(at)gmail(dot)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(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