Re: PostgreSQL Repos and archiving

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Gabriel Guillem Barceló Soteras <gbarcelo(at)parlamentib(dot)es>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL Repos and archiving
Date: 2026-05-12 07:41:21
Message-ID: 504d3ebc45b86cf8d7ff1f3772e20f86a09d85ce.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2026-05-12 at 06:24 +0000, Gabriel Guillem Barceló Soteras wrote:
> I’m looking for guidance on how others are handling PGDG YUM repository maintenance on RHEL-like systems.
>
> In our environment, we installed PostgreSQL 15 client libraries (postgresql15,libpq, etc.) across several
> hosts at a time when PostgreSQL 13 was still supported. As a result, thepgdg-redhat-all.repo file enabled
> multiple repositories (includingpgdg13).
>
> Now that PostgreSQL 13 has reached end-of-life, its repository has been moved to the archive, and the
> original URL no longer works. Because the repository remains enabled, dnf update fails when refreshing
> metadata. DNF skip_if_unavailabledoes not work because of the error code returned by the old repo (410?)
>
> How are handling this situation apart from deleting old repo?

The proper way of dealing with that is to keep the package pgdg-redhat-repo updated.
Then the reference to the repositories of versions that are no longer supported will
vanish automatically, and you won't encounter the problem.

At the same time, keep updating your installations to the latest minor release.
That way, you can be certain to have the latest minor release for v13 when it goes
out of support.

Needless to say, you should upgrade way before a version goes out of support.

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2026-05-13 19:57:13 Puzzling "INSERT has more expressions than target columns" error
Previous Message Gabriel Guillem Barceló Soteras 2026-05-12 06:24:46 PostgreSQL Repos and archiving