Problem
When checking to see the latest package list, I get this PostgreSQL error:
[root@centos8sx64 ~]# dnf list blueworx* Blueworx 64 kB/s | 3.6 kB 00:00 PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 2.9 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.1 kB/s | 659 B 00:00 Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG signature verification error: Bad GPG signature
Resolving the problem
The previous GPG signatures of the PostgreSQL RPM packages were weak and outdated, so on 3 January 2024 they published new repository RPMs which include new GPG keys, and also will sign all of the packages with the new keys.
Here is the PostgreSQL link which explains the issue, and how to update the keys:
https://yum.postgresql.org/news/pgdg-rpm-repo-gpg-key-update/.
For CentOS 8, the command will be:
dnf --disablerepo=* -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm