BUG #16225: EL8 - PGDG postgresql* packages conflict with appstream postgresql packages
The following bug has been logged on the website:
Bug reference: 16225
Logged by: Andrew Roffey
Email address: andrew@aroffey.id.au
PostgreSQL version: 11.6
Operating system: Oracle Linux 8
Description:
Hello
I noticed that the postgresql10/postgresql11 (etc.) packages were not
showing up on an Oracle Linux 8 installation. On closer inspection I found
that they were not being shown due to conflicting packages in the
ol8_appstream repository (I suspect it is the same for CentOS 8 and RHEL
8).
To reproduce:
$ yum config-manager --enable ol8_appstream && yum info postgresql
postgresql11
-> Shows the PostgreSQL 10.6 packages only from appstream despite PGDG
repository being enabled
$ yum config-manager --disable ol8_appstream && yum info postgresql
postgresql11
-> Shows the PostgreSQL 11 package from the PGDG repository
Expected behaviour would to be able to install postgresql (system-provided
version), postgresql10 and postgresql11, or at least to use the Appstream
and PostgreSQL repos at the same time
I suspect the "provides" list may be the cause of this:
$ rpm -q --provides postgresql11-11.6-2PGDG.rhel8.x86_64.rpm 2>/dev/null
postgresql >= 11.6-2PGDG.rhel8
postgresql11 = 11.6-2PGDG.rhel8
postgresql11(x86-64) = 11.6-2PGDG.rhel8
For comparison, the python3 package "provides" list in EL7:
$ rpm -q --provides python3-3.6.8-10.0.1.el7.x86_64.rpm 2>/dev/null
python(abi) = 3.6
python(abi) = 3.6
python3 = 3.6.8-10.0.1.el7
python3(x86-64) = 3.6.8-10.0.1.el7
python36 = 3.6.8-10.0.1.el7
python36(x86-64) = 3.6.8-10.0.1.el7
The following packages are unavailable when the appstream repository is
enabled:
postgresql11
postgresql11-contrib
postgresql11-docs
postgresql11-plperl
postgresql11-plpython3
postgresql11-pltcl
postgresql11-server
postgresql11-test
(and so on for postgresql10, ...)
These are the conflicting packages in appstream:
postgresql
postgresql-contrib
postgresql-docs
postgresql-plperl
postgresql-plpython3
postgresql-pltcl
postgresql-server
postgresql-test
Hi,
After further investigation, it looks to be related to the new DNF
module feature in EL8.
Workaround is to disable the postgresql module:
dnf module disable postgresql
After which, postgresql (ol8_appstream), postgresql10 (pgdg10) and
postgresql11 (pgdg11) are installable.
Still need to look further into how these modules work and if any
packaging changes could be done as a better fix for PGDG.
Andrew
On Thu, Jan 23, 2020 at 10:53 PM Andrew Roffey <andrew@aroffey.id.au> wrote:
Hi,
After further investigation, it looks to be related to the new DNF
module feature in EL8.Workaround is to disable the postgresql module:
dnf module disable postgresql
After which, postgresql (ol8_appstream), postgresql10 (pgdg10) and
postgresql11 (pgdg11) are installable.Still need to look further into how these modules work and if any
packaging changes could be done as a better fix for PGDG.
Hello!
Note that this disabling step has been documented on the download page
(https://www.postgresql.org/download/linux/redhat/) for some time, but
was not documented alongside the initial releases where it was needed.
But it was added in the middle of December last year.
--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/