Hello all,
I've found on the wiki ( https://wiki.postgresql.org/wiki/Packagers ) that the packagers list Is closed, so the first question is how to properly report a package issue?
Particularly I've realized, that in the repository list
/etc/yum.repos.d/pgdg-redhat-all.repo provided by https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
pgdg14-updates-debuginfo repository definition is missing.
Tested on CentOS7 VM:
[root@centos7-base ~]# yum -y repolist --enablerepo=pgdg*
...
repo id repo name status
base/7/x86_64 CentOS-7 - Base 10 072
epel/x86_64 Extra Packages for Enterprise Linux 7 - x86_64 13 687
extras/7/x86_64 CentOS-7 - Extras 500
pgdg-common/7/x86_64 PostgreSQL common RPMs for RHEL/CentOS 7 - x86_64 342
pgdg-common-srpm-testing/7/x86_64 PostgreSQL common testing SRPMs for RHEL/CentOS 7 - x86_64 189
pgdg-common-testing/7/x86_64 PostgreSQL common testing RPMs for RHEL/CentOS 7 - x86_64 342
pgdg-source-common/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Source 189
pgdg10/7/x86_64 PostgreSQL 10 for RHEL/CentOS 7 - x86_64 1 003
pgdg10-source/7/x86_64 PostgreSQL 10 for RHEL/CentOS 7 - x86_64 - Source 519
pgdg10-updates-debuginfo/7/x86_64 PostgreSQL 10 for RHEL/CentOS 7 - x86_64 - Debuginfo 405
pgdg11/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 1 111
pgdg11-source/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Source 535
pgdg11-source-updates-testing/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Source update testing 0
pgdg11-updates-debuginfo/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Debuginfo 411
pgdg11-updates-testing/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Updates testing 6
pgdg11-updates-testing-debuginfo/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Debuginfo 1
pgdg12/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 693
pgdg12-source/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Source 379
pgdg12-source-updates-testing/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Source update testing 0
pgdg12-updates-debuginfo/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Debuginfo 283
pgdg12-updates-testing/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Updates testing 0
pgdg12-updates-testing-debuginfo/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Debuginfo 0
pgdg13/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 436
pgdg13-source-updates-testing/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 - Source updates testing 0
pgdg13-updates-debuginfo/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 - Debuginfo 176
pgdg13-updates-testing/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 - Updates testing 0
pgdg13-updates-testing-debuginfo/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 - Debuginfo 0
pgdg14/7/x86_64 PostgreSQL 14 for RHEL/CentOS 7 - x86_64 173
pgdg14-source-updates-testing/7/x86_64 PostgreSQL 14 for RHEL/CentOS 7 - x86_64 - Source updates testing 0
pgdg14-updates-testing/7/x86_64 PostgreSQL 14 for RHEL/CentOS 7 - x86_64 - Updates testing 1
pgdg14-updates-testing-debuginfo/7/x86_64 PostgreSQL 14 for RHEL/CentOS 7 - x86_64 - Debuginfo 1
pgdg15-updates-testing/7/x86_64 PostgreSQL 15 for RHEL/CentOS 7 - x86_64 - Updates testing 77
pgdg96/7/x86_64 PostgreSQL 9.6 for RHEL/CentOS 7 - x86_64 959
pgdg96-source/7/x86_64 PostgreSQL 9.6 for RHEL/CentOS 7 - x86_64 - Source 481
pgdg96-updates-debuginfo/7/x86_64 PostgreSQL 9.6 for RHEL/CentOS 7 - x86_64 - Debuginfo 394
updates/7/x86_64 CentOS-7 - Updates 2 963
repolist: 36 328
base/7/x86_64 CentOS-7 - Base 10 072
epel/x86_64 Extra Packages for Enterprise Linux 7 - x86_64 13 687
extras/7/x86_64 CentOS-7 - Extras 500
pgdg-common/7/x86_64 PostgreSQL common RPMs for RHEL/CentOS 7 - x86_64 342
pgdg-common-srpm-testing/7/x86_64 PostgreSQL common testing SRPMs for RHEL/CentOS 7 - x86_64 189
pgdg-common-testing/7/x86_64 PostgreSQL common testing RPMs for RHEL/CentOS 7 - x86_64 342
pgdg-source-common/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Source 189
pgdg10/7/x86_64 PostgreSQL 10 for RHEL/CentOS 7 - x86_64 1 003
pgdg10-source/7/x86_64 PostgreSQL 10 for RHEL/CentOS 7 - x86_64 - Source 519
pgdg10-updates-debuginfo/7/x86_64 PostgreSQL 10 for RHEL/CentOS 7 - x86_64 - Debuginfo 405
pgdg11/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 1 111
pgdg11-source/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Source 535
pgdg11-source-updates-testing/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Source update testing 0
pgdg11-updates-debuginfo/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Debuginfo 411
pgdg11-updates-testing/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Updates testing 6
pgdg11-updates-testing-debuginfo/7/x86_64 PostgreSQL 11 for RHEL/CentOS 7 - x86_64 - Debuginfo 1
pgdg12/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 693
pgdg12-source/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Source 379
pgdg12-source-updates-testing/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Source update testing 0
pgdg12-updates-debuginfo/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Debuginfo 283
pgdg12-updates-testing/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Updates testing 0
pgdg12-updates-testing-debuginfo/7/x86_64 PostgreSQL 12 for RHEL/CentOS 7 - x86_64 - Debuginfo 0
pgdg13/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 436
pgdg13-source-updates-testing/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 - Source updates testing 0
pgdg13-updates-debuginfo/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 - Debuginfo 176
pgdg13-updates-testing/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 - Updates testing 0
pgdg13-updates-testing-debuginfo/7/x86_64 PostgreSQL 13 for RHEL/CentOS 7 - x86_64 - Debuginfo 0
pgdg14/7/x86_64 PostgreSQL 14 for RHEL/CentOS 7 - x86_64 173
pgdg14-source-updates-testing/7/x86_64 PostgreSQL 14 for RHEL/CentOS 7 - x86_64 - Source updates testing 0
pgdg14-updates-testing/7/x86_64 PostgreSQL 14 for RHEL/CentOS 7 - x86_64 - Updates testing 1
pgdg14-updates-testing-debuginfo/7/x86_64 PostgreSQL 14 for RHEL/CentOS 7 - x86_64 - Debuginfo 1
pgdg15-updates-testing/7/x86_64 PostgreSQL 15 for RHEL/CentOS 7 - x86_64 - Updates testing 77
pgdg96/7/x86_64 PostgreSQL 9.6 for RHEL/CentOS 7 - x86_64 959
pgdg96-source/7/x86_64 PostgreSQL 9.6 for RHEL/CentOS 7 - x86_64 - Source 481
pgdg96-updates-debuginfo/7/x86_64 PostgreSQL 9.6 for RHEL/CentOS 7 - x86_64 - Debuginfo 394
updates/7/x86_64 CentOS-7 - Updates 2 963
repolist: 36 328
[root@centos7-base ~]# yum -y info postgresql14-debuginfo
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.karneval.cz
* epel: mirror.karneval.cz
* extras: mirror.karneval.cz
* updates: mirror.karneval.cz
Error: No matching Packages to list
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.karneval.cz
* epel: mirror.karneval.cz
* extras: mirror.karneval.cz
* updates: mirror.karneval.cz
Error: No matching Packages to list
Adding the missing repository section:
# Debuginfo/debugsource packages for stable repos
[pgdg14-updates-debuginfo]
name=PostgreSQL 14 for RHEL/CentOS $releasever - $basearch - Debuginfo
baseurl=https://download.postgresql.org/pub/repos/yum/debug/14/redhat/rhel-$releasever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
repo_gpgcheck = 1
[pgdg14-updates-debuginfo]
name=PostgreSQL 14 for RHEL/CentOS $releasever - $basearch - Debuginfo
baseurl=https://download.postgresql.org/pub/repos/yum/debug/14/redhat/rhel-$releasever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
repo_gpgcheck = 1
Fix it, as expected:
[root@centos7-base ~]# yum -y --enablerepo=pgdg14-updates-debuginfo search postgresql14-debuginfo
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.karneval.cz
* epel: mirror.karneval.cz
* extras: mirror.karneval.cz
* updates: mirror.karneval.cz
================ N/S matched: postgresql14-debuginfo ================
postgresql14-debuginfo.x86_64 : Debug information for package postgresql14
Name and summary matches only, use "search all" for everything.
[root@centos7-base ~]# yum -y --enablerepo=pgdg14-updates-debuginfo info postgresql14-debuginfo
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.karneval.cz
* epel: mirror.karneval.cz
* extras: mirror.karneval.cz
* updates: mirror.karneval.cz
Available Packages
Name : postgresql14-debuginfo
Arch : x86_64
Version : 14.1
Release : 1PGDG.rhel7
Size : 12 M
Repo : pgdg14-updates-debuginfo/7/x86_64
Summary : Debug information for package postgresql14
URL : https://www.postgresql.org/
License : PostgreSQL
Description : This package provides debug information for package postgresql14.
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.karneval.cz
* epel: mirror.karneval.cz
* extras: mirror.karneval.cz
* updates: mirror.karneval.cz
================ N/S matched: postgresql14-debuginfo ================
postgresql14-debuginfo.x86_64 : Debug information for package postgresql14
Name and summary matches only, use "search all" for everything.
[root@centos7-base ~]# yum -y --enablerepo=pgdg14-updates-debuginfo info postgresql14-debuginfo
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.karneval.cz
* epel: mirror.karneval.cz
* extras: mirror.karneval.cz
* updates: mirror.karneval.cz
Available Packages
Name : postgresql14-debuginfo
Arch : x86_64
Version : 14.1
Release : 1PGDG.rhel7
Size : 12 M
Repo : pgdg14-updates-debuginfo/7/x86_64
Summary : Debug information for package postgresql14
URL : https://www.postgresql.org/
License : PostgreSQL
Description : This package provides debug information for package postgresql14.
: Debug information is useful when developing applications that use this
: package or when debugging this package.
: package or when debugging this package.
What is the right way to report this issue? I've also found a few things in the /usr/pgsql-14/bin/postgresql-14-setup script (applies at least starting from PG 12, haven't checked older versions) to discuss or potentially patch if considered as an improvement.
Kind regards Ales Zeleny
