Thread: BUG #18508: Not all packages are present in the repo on rhel 8

BUG #18508: Not all packages are present in the repo on rhel 8

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      18508
Logged by:          David M. Pulkowski
Email address:      dpulkowski@uwhealth.org
PostgreSQL version: 16.3
Operating system:   RHEL 8
Description:

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

When following this for setting up the repo. All works fine for rhel8 &
rhel9.
Yet, what dnf sees on the repo differs in rhel8 vs rhel9 and I cant seem to
figure why or what is wrong, as the process of adding the repo was the
same.
If I browse to the repo in a web-browser I can see the package there, but
dnf can see it on rhel8?

RHEL8
```
cat /etc/redhat-release
Red Hat Enterprise Linux release 8.10 (Ootpa)
```
Rhel 8 (abridged list)
```
 yum repolist

pgdg-common
                 PostgreSQL common RPMs for RHEL / Rocky / AlmaLinux 8 -
x86_64
pgdg12
                 PostgreSQL 12 for RHEL / Rocky / AlmaLinux 8 - x86_64
pgdg13
                 PostgreSQL 13 for RHEL / Rocky / AlmaLinux 8 - x86_64
pgdg14
                 PostgreSQL 14 for RHEL / Rocky / AlmaLinux 8 - x86_64
pgdg15
                 PostgreSQL 15 for RHEL / Rocky / AlmaLinux 8 - x86_64
pgdg16
                 PostgreSQL 16 for RHEL / Rocky / AlmaLinux 8 - x86_64
```
List packages in repo and search for posgres16 on rhel 8:
```
dnf repository-packages pgdg16 list | grep postgresql16
postgresql16-libs.x86_64                     16.3-3PGDG.rhel8
@pgdg16
postgresql16-devel.x86_64                    16.3-3PGDG.rhel8
pgdg16
postgresql16-llvmjit.x86_64                  16.3-3PGDG.rhel8
pgdg16
postgresql16-odbc.x86_64                     16.00.0000-1PGDG.rhel8
pgdg16
postgresql16-tcl.x86_64                      3.0.0-2.rhel8.1
pgdg16
```

RHEL 9
```
cat /etc/redhat-release
Red Hat Enterprise Linux release 9.3 (Plow)
```

Same setup but on rhel 9 (abridged list)
```
yum repolist

pgdg-common
              PostgreSQL common RPMs for RHEL / Rocky / AlmaLinux 9 -
x86_64
pgdg12
              PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64
pgdg13
              PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64
pgdg14
              PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64
pgdg15
              PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64
pgdg16
              PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64
```
List packages in repo and search for posgres16 on rhel 9:
```
dnf repository-packages pgdg16 list | grep postgresql16
Repository ol9_oracle_instantclient is listed more than once in the
configuration
postgresql16.x86_64                          16.3-1PGDG.rhel9
@pgdg16
postgresql16-devel.x86_64                    16.3-1PGDG.rhel9
@pgdg16
postgresql16-libs.x86_64                     16.3-1PGDG.rhel9
@pgdg16
postgresql16-contrib.x86_64                  16.3-1PGDG.rhel9
pgdg16
postgresql16-docs.x86_64                     16.3-1PGDG.rhel9
pgdg16
postgresql16-llvmjit.x86_64                  16.3-1PGDG.rhel9
pgdg16
postgresql16-odbc.x86_64                     16.00.0000-1PGDG.rhel9
pgdg16
postgresql16-plperl.x86_64                   16.3-1PGDG.rhel9
pgdg16
postgresql16-plpython3.x86_64                16.3-1PGDG.rhel9
pgdg16
postgresql16-pltcl.x86_64                    16.3-1PGDG.rhel9
pgdg16
postgresql16-server.x86_64                   16.3-1PGDG.rhel9
pgdg16
postgresql16-tcl.x86_64                      3.0.0-2.rhel9.1
pgdg16
postgresql16-test.x86_64                     16.3-1PGDG.rhel9
pgdg16
```


Re: BUG #18508: Not all packages are present in the repo on rhel 8

From
Robert Treat
Date:
On Fri, Jun 14, 2024 at 9:58 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      18508
> Logged by:          David M. Pulkowski
> Email address:      dpulkowski@uwhealth.org
> PostgreSQL version: 16.3
> Operating system:   RHEL 8
> Description:
>
> https://www.postgresql.org/download/linux/redhat/
>
> When following this for setting up the repo. All works fine for rhel8 &
> rhel9.
> Yet, what dnf sees on the repo differs in rhel8 vs rhel9 and I cant seem to
> figure why or what is wrong, as the process of adding the repo was the
> same.
> If I browse to the repo in a web-browser I can see the package there, but
> dnf can see it on rhel8?
>
> RHEL8
> ```
> cat /etc/redhat-release
> Red Hat Enterprise Linux release 8.10 (Ootpa)
> ```
> Rhel 8 (abridged list)
> ```
>  yum repolist
>
> pgdg-common
>                  PostgreSQL common RPMs for RHEL / Rocky / AlmaLinux 8 -
> x86_64
> pgdg12
>                  PostgreSQL 12 for RHEL / Rocky / AlmaLinux 8 - x86_64
> pgdg13
>                  PostgreSQL 13 for RHEL / Rocky / AlmaLinux 8 - x86_64
> pgdg14
>                  PostgreSQL 14 for RHEL / Rocky / AlmaLinux 8 - x86_64
> pgdg15
>                  PostgreSQL 15 for RHEL / Rocky / AlmaLinux 8 - x86_64
> pgdg16
>                  PostgreSQL 16 for RHEL / Rocky / AlmaLinux 8 - x86_64
> ```
> List packages in repo and search for posgres16 on rhel 8:
> ```
> dnf repository-packages pgdg16 list | grep postgresql16
> postgresql16-libs.x86_64                     16.3-3PGDG.rhel8
> @pgdg16
> postgresql16-devel.x86_64                    16.3-3PGDG.rhel8
> pgdg16
> postgresql16-llvmjit.x86_64                  16.3-3PGDG.rhel8
> pgdg16
> postgresql16-odbc.x86_64                     16.00.0000-1PGDG.rhel8
> pgdg16
> postgresql16-tcl.x86_64                      3.0.0-2.rhel8.1
> pgdg16
> ```
>
> RHEL 9
> ```
> cat /etc/redhat-release
> Red Hat Enterprise Linux release 9.3 (Plow)
> ```
>
> Same setup but on rhel 9 (abridged list)
> ```
> yum repolist
>
> pgdg-common
>               PostgreSQL common RPMs for RHEL / Rocky / AlmaLinux 9 -
> x86_64
> pgdg12
>               PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64
> pgdg13
>               PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64
> pgdg14
>               PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64
> pgdg15
>               PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64
> pgdg16
>               PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64
> ```
> List packages in repo and search for posgres16 on rhel 9:
> ```
> dnf repository-packages pgdg16 list | grep postgresql16
> Repository ol9_oracle_instantclient is listed more than once in the
> configuration
> postgresql16.x86_64                          16.3-1PGDG.rhel9
> @pgdg16
> postgresql16-devel.x86_64                    16.3-1PGDG.rhel9
> @pgdg16
> postgresql16-libs.x86_64                     16.3-1PGDG.rhel9
> @pgdg16
> postgresql16-contrib.x86_64                  16.3-1PGDG.rhel9
> pgdg16
> postgresql16-docs.x86_64                     16.3-1PGDG.rhel9
> pgdg16
> postgresql16-llvmjit.x86_64                  16.3-1PGDG.rhel9
> pgdg16
> postgresql16-odbc.x86_64                     16.00.0000-1PGDG.rhel9
> pgdg16
> postgresql16-plperl.x86_64                   16.3-1PGDG.rhel9
> pgdg16
> postgresql16-plpython3.x86_64                16.3-1PGDG.rhel9
> pgdg16
> postgresql16-pltcl.x86_64                    16.3-1PGDG.rhel9
> pgdg16
> postgresql16-server.x86_64                   16.3-1PGDG.rhel9
> pgdg16
> postgresql16-tcl.x86_64                      3.0.0-2.rhel9.1
> pgdg16
> postgresql16-test.x86_64                     16.3-1PGDG.rhel9
> pgdg16
> ```
>

Hey David, issues with rpms should be reported to the rpm maintainers.
You can do that via the rpm bug tracker or rpm packagin mailing list.
More info on both can be found at https://yum.postgresql.org/contact/.
Hope this helps.

Robert Treat
https://xzilla.net