Thread: RPM package issue

RPM package issue

From

Aleš Zelený

Date:

24 November 2021, 19:47:40

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

[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

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

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.

: Debug information is useful when developing applications that use this
: 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

Re: RPM package issue

From

Adrian Klaver

Date:

24 November 2021, 20:16:55

On 11/24/21 08:47, Aleš Zelený wrote:
> Hello all,
> 
> I've found on the wiki ( https://wiki.postgresql.org/wiki/Packagers 
> <https://wiki.postgresql.org/wiki/Packagers> ) that the packagers list 
> Is closed, so the first question is how to properly report a package issue?

https://www.postgresql.org/download/linux/redhat/ -->:
    
    https://yum.postgresql.org/ -->:

        https://yum.postgresql.org/contact/

Or issue tracker:

https://redmine.postgresql.org/projects/pgrpms/

though you will need to setup/have a Postgres community account to access.

> 
> 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 
> <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.

> Kind regards Ales Zeleny


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: RPM package issue

From

Adrian Klaver

Date:

24 November 2021, 20:22:04

On 11/24/21 08:47, Aleš Zelený wrote:
> Hello all,
> 
> I've found on the wiki ( https://wiki.postgresql.org/wiki/Packagers 
> <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 
> <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.

This was reported and fixed?:

https://redmine.postgresql.org/issues/6849

Again you will need community account to access.

> 

> Kind regards Ales Zeleny


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: RPM package issue

From

Aleš Zelený

Date:

24 November 2021, 20:51:57

Hi Adrian,

thanks for the hint!

Ales

st 24. 11. 2021 v 18:16 odesílatel Adrian Klaver <adrian.klaver@aklaver.com> napsal:

On 11/24/21 08:47, Aleš Zelený wrote:
> Hello all,
>
> I've found on the wiki ( https://wiki.postgresql.org/wiki/Packagers
> <https://wiki.postgresql.org/wiki/Packagers> ) that the packagers list
> Is closed, so the first question is how to properly report a package issue?

https://www.postgresql.org/download/linux/redhat/ -->:

https://yum.postgresql.org/ -->:

https://yum.postgresql.org/contact/

Or issue tracker:

https://redmine.postgresql.org/projects/pgrpms/

though you will need to setup/have a Postgres community account to access.

>
> 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
> <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.

> Kind regards Ales Zeleny

--
Adrian Klaver
adrian.klaver@aklaver.com