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

The following bug has been logged on the website:

Bug reference:      15765
Logged by:          Daniel Black
Email address:      daniel@linux.ibm.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@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@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@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