PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15765
PG Version9.6.12
OSRHEL7
Opened2019-04-17 07:55:11+00
Reported byDaniel Black
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15765
Logged by:          Daniel Black
Email address:      (redacted)
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

Messages

DateAuthorSubject
2019-04-17 07:55:11+00PG Bug reporting formBUG #15765: pgdg-redhat-repo-42.0-3 gpgkey entries don't exist in /etc/yum.repos.d/pgdg-redhat-all.repo