Обсуждение: 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/