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.
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
Från: Pär Mattsson
Skickat: den 11 september 2024 09:13
Till: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Ä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
