Errors in pgdg repo packages

Started by Kevin Struckhoff17 days ago6 messagesbugs
Jump to latest
#1Kevin Struckhoff
kevinstruckhoff@yahoo.com

Hello,
During my monthly server update process, I'm getting 404 errors in the pgdg18 and pgdg-common repo packages.
/root>yum check-update
PostgreSQL common RPMs for RHEL / Rocky Linux / AlmaLinux 10. - x86_64                  1.5 kB/s | 146  B     00:00
Errors during downloading metadata for repository 'pgdg-common':
  - Status code: 404 for https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-10.-x86_64/repodata/repomd.xml (IP: 151.101.195.52)
Error: Failed to download metadata for repo 'pgdg-common': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried

Same error for repo pgdg18.
I've disabled all pgdg repos in order to move forward. 
Thanks. Kevin

#2Daniel Gustafsson
daniel@yesql.se
In reply to: Kevin Struckhoff (#1)
Re: Errors in pgdg repo packages

On 5 Nov 2026, at 20:12, Kevin Struckhoff <kevinstruckhoff@yahoo.com> wrote:

During my monthly server update process, I'm getting 404 errors in the pgdg18 and pgdg-common repo packages.

I think that's expected for RHEL 10:

https://yum.postgresql.org/news/rhel-10.0-9.6-retirement/

--
Daniel Gustafsson

#3Magnus Hagander
magnus@hagander.net
In reply to: Kevin Struckhoff (#1)
Re: Errors in pgdg repo packages

On Thu, 5 Nov 2026 at 20:13, Kevin Struckhoff <kevinstruckhoff@yahoo.com>
wrote:

Hello,

During my monthly server update process, I'm getting 404 errors in the
pgdg18 and pgdg-common repo packages.

/root>yum check-update
PostgreSQL common RPMs for RHEL / Rocky Linux / AlmaLinux 10. - x86_64
1.5 kB/s | 146 B 00:00
Errors during downloading metadata for repository 'pgdg-common':
- Status code: 404 for
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-10.-x86_64/repodata/repomd.xml
(IP: 151.101.195.52)
Error: Failed to download metadata for repo 'pgdg-common': Cannot download
repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried

Same error for repo pgdg18.

I've disabled all pgdg repos in order to move forward.

You have an extra period in the URL. The correct URL for that file is
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-10-x86_64/repodata/repomd.xml

//Magnus

#4Kevin Struckhoff
kevinstruckhoff@yahoo.com
In reply to: Magnus Hagander (#3)
Re: Errors in pgdg repo packages

The pgdg repo file is corrupted on my server and was installed that way. It needs to be replaced.
what is the correct repo file url? 
Thanks. Kevin

On Friday, November 6, 2026 at 07:47:28 AM PST, Magnus Hagander <magnus@hagander.net> wrote:

On Thu, 5 Nov 2026 at 20:13, Kevin Struckhoff <kevinstruckhoff@yahoo.com> wrote:

Hello,
During my monthly server update process, I'm getting 404 errors in the pgdg18 and pgdg-common repo packages.
/root>yum check-update
PostgreSQL common RPMs for RHEL / Rocky Linux / AlmaLinux 10. - x86_64                  1.5 kB/s | 146  B     00:00
Errors during downloading metadata for repository 'pgdg-common':
  - Status code: 404 for https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-10.-x86_64/repodata/repomd.xml (IP: 151.101.195.52)
Error: Failed to download metadata for repo 'pgdg-common': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried

Same error for repo pgdg18.
I've disabled all pgdg repos in order to move forward. 

You have an extra period in the URL. The correct URL for that file is https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-10-x86_64/repodata/repomd.xml
//Magnus 

#5Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: Kevin Struckhoff (#4)
Re: Errors in pgdg repo packages

Hi,

On Sat, 2026-11-07 at 19:33 +0000, Kevin Struckhoff wrote:

The pgdg repo file is corrupted on my server and was installed that
way. It needs to be replaced. what is the correct repo file url? 

Looks like you are using an unsupported distro like CentOS Stream of
Oracle Linux which lacks $releasever_minor in dnf. We support RHEL,
AlmaLinux and Rocky Linux (probably more as long as they don't lack that
variable). Recent repo files check that variable to construct the URLs:

https://yum.postgresql.org/news/repo-rpms-follow-os-minor-version/

Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
BlueSky: @devrim.gunduz.org , @gunduz.org

#6Kevin Struckhoff
kevinstruckhoff@yahoo.com
In reply to: Devrim GÜNDÜZ (#5)
Re: Errors in pgdg repo packages

I would never use an oracle product. I'd retire first. I've been using RHEL/Centos for 15+ years and switched to Centos Stream at V8. I've been using postgresql for 13+ years. 
even the update repo fails:

dnf update pgdg-redhat-repo

PostgreSQL common RPMs for RHEL / Rocky Linux / AlmaLinux 10. - x86_64                  497 kB/s | 163 kB     00:00
PostgreSQL 18 for RHEL / Rocky Linux / AlmaLinux 10. - x86_64                           519 kB/s | 177 kB     00:00
PostgreSQL 17 for RHEL / Rocky Linux / AlmaLinux 10. - x86_64                           620  B/s | 146  B     00:00
Errors during downloading metadata for repository 'pgdg17':
  - Status code: 404 for https://download.postgresql.org/pub/repos/yum/17/redhat/rhel-10.-x86_64/repodata/repomd.xml (IP: 151.101.67.52)
Error: Failed to download metadata for repo 'pgdg17': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried

So the only solution that has worked for me is a manual edit of the repo file. 

Thanks. Kevin

On Monday, November 9, 2026 at 02:01:10 AM PST, Devrim Gündüz <devrim@gunduz.org> wrote:

Hi,

On Sat, 2026-11-07 at 19:33 +0000, Kevin Struckhoff wrote:

The pgdg repo file is corrupted on my server and was installed that
way. It needs to be replaced. what is the correct repo file url? 

Looks like you are using an unsupported distro like CentOS Stream of
Oracle Linux which lacks $releasever_minor in dnf. We support RHEL,
AlmaLinux and Rocky Linux (probably more as long as they don't lack that
variable). Recent repo files check that variable to construct the URLs:

https://yum.postgresql.org/news/repo-rpms-follow-os-minor-version/

Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
BlueSky: @devrim.gunduz.org , @gunduz.org