BUG #18895: Installation failure on Fedora 42 due to missing repos

PG Bug reporting form <noreply@postgresql.org>

From: PG Bug reporting form <noreply@postgresql.org>

To: pgsql-bugs@lists.postgresql.org

Cc: buschmann@nidsa.net

Date: 2025-04-16T08:59:35Z

Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference:      18895
Logged by:          Hans Buschmann
Email address:      buschmann@nidsa.net
PostgreSQL version: 17.4
Operating system:   Fedora 42 Server x86-64
Description:        

Following the official availability of Fedora 42 on April 15 2025 I tried to
upgrade some virtual machines with Fedora server x86-64.

In all cases Postgres 17.4 was installed from PGDG repositories (not the
builtin version)

Postgres blocked the upgrade, so I removed all postgresql17* packages. The
general upgrade of Fedora 41 to Fedora 42 then was successfull.

Trying to install the new repo from the installation website with:

sudo dnf install -y
https://download.postgresql.org/pub/repos/yum/reporpms/F-42-x86_64/pgdg-fedora-repo-latest.noarch.rpm

resulted in:

Failed to download files
 Librepo error: Status code: 404 for
https://download.postgresql.org/pub/repos/yum/reporpms/F-42-x86_64/pgdg-fedora-repo-latest.noarch.rpm
(IP: 2a04:4e42:8e::820)

I manually installed the repo from
https://ftp.postgresql.org/pub/repos/yum/reporpms/F-42-x86_64/pgdg-fedora-repo-42.0-36PGDG.noarch.rpm

But further installation gave me:
[root@linux ~]# dnf list postgresql17*
Updating and loading repositories:
 PostgreSQL common RPMs for Fedora 42 - x86_64                              
                    100% |   5.1 KiB/s | 584.0   B |  00m00s
>>> Status code: 404 for
https://download.postgresql.org/pub/repos/yum/common/fedora/fedora-42-x86_64/repodata/repomd.xml
(IP: 2a04:4e42:
.. etc...

By looking to directory
https://ftp.postgresql.org/pub/repos/yum/common/fedora/

./
fedora-40-x86_64/                                  14-Apr-2025 14:11        
          -
fedora-41-x86_64/                                  14-Apr-2025 14:11        
          -

I noticed that fedora-42 is missing there.

This may be the reason for the installation failure.

Perhaps I am missing something else so please give me some advise...

Thanks in advance

Hans Buschmann