BUG #18339: Erroneous dependency references of Postgres 15.4 packages when installing 16.2 from GPDG repository - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18339: Erroneous dependency references of Postgres 15.4 packages when installing 16.2 from GPDG repository
Date
Msg-id 18339-f9dda01a46c0432f@postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18339
Logged by:          Hans Buschmann
Email address:      buschmann@nidsa.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@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


pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #18338: Memory leak in function 'dumpRule'
Next
From: PG Bug reporting form
Date:
Subject: BUG #18340: BitString may break nodetoString() conversion for a raw parse tree