Re: BUG #18508: Not all packages are present in the repo on rhel 8 - Mailing list pgsql-bugs

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