pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: buschmann@nidsa.net
Subject: BUG #18339: Erroneous dependency references of Postgres 15.4 packages when installing 16.2 from GPDG repository
Date: Mon, 12 Feb 2024 18:44:32 +0000
Message-ID: <18339-f9dda01a46c0432f@postgresql.org> (raw)

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



Message-ID: <18339-f9dda01a46c0432f@postgresql.org>
Permalink:  ../18339-f9dda01a46c0432f@postgresql.org/
Also on:    postgresql.org/message-id/18339-f9dda01a46c0432f@postgresql.org

 · 

reply

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, buschmann@nidsa.net
  Subject: Re: BUG #18339: Erroneous dependency references of Postgres 15.4 packages when installing 16.2 from GPDG repository
  In-Reply-To: <18339-f9dda01a46c0432f@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