The following bug has been logged on the website:
Bug reference: 17507
Logged by: Stefan Bluhm
Email address: postgresql.org@bluhm-de.com
PostgreSQL version: 14.3
Operating system: AlmaLinux9
Description:
Issue:
The provided rpm packages provide incorrect postgersql version information
for PostgreSQL 14.* (only tested 14).
How to reproduce:
- Use Enterprise Linux 8 or 9.
- Use the packages from repositories
https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
or
https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
- check the provided versions:
# dnf repoquery --provides postgresql14
Output:
postgresql >= 14.0-1PGDG.rhel8
postgresql >= 14.1-1PGDG.rhel8
postgresql >= 14.2-1PGDG.rhel8
postgresql >= 14.2-4PGDG.rhel8
postgresql >= 14.3-1PGDG.rhel8
This is false. a package shouldn't provide ">=" a specific version. This
will cause resolution errors with librepo.
Example RPM line
Requires: postgresql >= 14
Conflicts: postgresql > 20
User expectation: Postgresql 14 or higher will be installed. Postgresql 20
or higher will not be installed.
Actually nothing will be installed. Postgresql 14 will be selected for
installation but conflicts with itself as it is also providing anything
higher than 20.