BUG #15765: pgdg-redhat-repo-42.0-3 gpgkey entries don't exist in /etc/yum.repos.d/pgdg-redhat-all.repo

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: daniel(at)linux(dot)ibm(dot)com
Subject: BUG #15765: pgdg-redhat-repo-42.0-3 gpgkey entries don't exist in /etc/yum.repos.d/pgdg-redhat-all.repo
Date: 2019-04-17 07:55:11
Message-ID: 15765-8d64f5f1f4cbc45e@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15765
Logged by: Daniel Black
Email address: daniel(at)linux(dot)ibm(dot)com
PostgreSQL version: 9.6.12
Operating system: RHEL7
Description:

The gpgkey entries in /etc/yum.repos.d/pgdg-redhat-all.repo all should be
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG

To reproduce:

$ docker run --rm -it registry.access.redhat.com/rhel7/rhel bash
[root(at)fcdc82a2d430 /]# yum install
https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-ppc64le/pgdg-redhat-repo-latest.noarch.rpm
Loaded plugins: ovl, product-id, search-disabled-repos,
subscription-manager
This system is not registered with an entitlement server. You can use
subscription-manager to register.
Examining /var/tmp/yum-root-um11t2/pgdg-redhat-repo-latest.noarch.rpm:
pgdg-redhat-repo-42.0-3.noarch
Marking /var/tmp/yum-root-um11t2/pgdg-redhat-repo-latest.noarch.rpm to be
installed
Resolving Dependencies
--> Running transaction check
---> Package pgdg-redhat-repo.noarch 0:42.0-3 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================================================
Package Arch Version
Repository
Size
================================================================================================================================================================
Installing:
pgdg-redhat-repo noarch 42.0-3
/pgdg-redhat-repo-latest.noarch
6.8 k

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

Total size: 6.8 k
Installed size: 6.8 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : pgdg-redhat-repo-42.0-3.noarch

1/1
Verifying : pgdg-redhat-repo-42.0-3.noarch

1/1

Installed:
pgdg-redhat-repo.noarch 0:42.0-3

Complete!
[root(at)fcdc82a2d430 /]# rpm -ql pgdg-redhat-repo-42.0-3
/etc/pki/rpm-gpg
/etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
/etc/yum.repos.d/pgdg-redhat-all.repo
[root(at)fcdc82a2d430 /]# grep PGDG /etc/yum.repos.d/pgdg-redhat-all.repo
# PGDG Red Hat Enterprise Linux / CentOS / Scientific Linux stable
repositories:
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-12
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-11
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-10
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-96
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-95
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-94
# PGDG Fedora Updates Testing repositories (These packages should not be
used in production)
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-12
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-11
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-10
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-96
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-12
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-12
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-11
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-11
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-10
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-10
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-96
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-96
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-95
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-94

Also for ppc64le postgresql-9.4 doesn't exists so there shouldn't be a repo
entry for it. A postinstall script like the following maybe:

[ $(uname -m) = ppc64le ] && sed -i -e '/pgdg94/,/^$/d'
/etc/yum.repos.d/pgdg-redhat-all.repo

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim Gündüz 2019-04-17 07:55:12 Re: Fw: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication
Previous Message Devrim Gündüz 2019-04-17 07:02:06 Re: BUG #15764: Yum repo/key name mismatch