From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: postgresql.org@bluhm-de.com
Subject: BUG #17507: rpm packages provide wrong postgresql version
Date: Wed, 01 Jun 2022 19:49:22 +0000
Message-ID: <17507-7c4325dda6d8445f@postgresql.org> (raw)
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.rp...
or
https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rp...
- 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, postgresql.org@bluhm-de.com
Subject: Re: BUG #17507: rpm packages provide wrong postgresql version
In-Reply-To: <17507-7c4325dda6d8445f@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox