BUG #18339: Erroneous dependency references of Postgres 15.4 packages when installing 16.2 from GPDG repository

The following bug has been logged on the website:

Bug reference: 18339
Logged by: Hans Buschmann
Email address: buschmann(at)nidsa(dot)net
PostgreSQL version: 16.2
Operating system: Fedora 39 on x86-64 64bit
Description:

I recently installed Postgres 16.2 from PGDG repositories on a fresh Fedora
39 Server VM as described on download page.

I first installed the Repository rpm.

By installing the necessary postgres components I got:

[root(at)localhost ~]# sudo dnf install postgresql16 postgresql16-server
postgresql16-contrib postgresql16-libs
Letzte Prüfung auf abgelaufene Metadaten: vor 0:01:32 am So 11 Feb 2024
12:10:27 CET.
Abhängigkeiten sind aufgelöst.
====================================================================================================
Paket Architektur Version
Paketquelle Größe
====================================================================================================
Installieren:
postgresql16 x86_64 16.2-1PGDG.f39
pgdg16 1.8 M
postgresql16-contrib x86_64 16.2-1PGDG.f39
pgdg16 723 k
postgresql16-server x86_64 16.2-1PGDG.f39
pgdg16 6.8 M
Abhängigkeiten werden installiert:
lz4 x86_64 1.9.4-4.fc39
fedora 103 k
postgresql x86_64 15.4-1.fc39
fedora 1.7 M
postgresql-private-libs x86_64 15.4-1.fc39
fedora 142 k
postgresql16-libs x86_64 16.2-1PGDG.f39
pgdg16 332 k
Schwache Abhängigkeiten werden installiert:
postgresql-server x86_64 15.4-1.fc39
fedora 6.2 M

(Abhängigkeiten=dependencies, schwach=week)

The 3 packages from 15.4 are wrong and harm the installation.

I managed to exclude the pg15 packages by restricting the repository to
pgdg16.

The same behavior was already observed before when upgrading other instances
from pg16.0 or pg16.1.

When these 15.4 packages are blindly co-installed, the default path in
Fedora points to the pg15 installation and e.g. some recent options of
pg_dump don't work because of the older version.

You can manually uninstall the pg15.4 packages afterwords, but this leaves
the path unset..

Very annoying...

I hope someone can check the dependencies during install as I am not
familiar with detailed rpm package properties.

Thank you for looking

Hans Buschmann