Looks like something is wrong with the PGDG repo RPM for PostgreSQL 10 on Oracle Linux 6…

This works fine: yum install -y https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgdg-oraclelinux10-10-2.noarch.rpm

But something is wrong with the URL that gets configured. Subsequent yum commands error out:

https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6Server-x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found"
Trying other mirror.
Error: Cannot retrieve repository metadata (repomd.xml) for repository: pgdg10. Please verify its path and try again

Comparing https://download.postgresql.org/pub/repos/yum/9.6/redhat/ to https://download.postgresql.org/pub/repos/yum/10/redhat/, it appears the problem is the lack of the four rhel-6(Server|Workstation)-(i386|x86_64) folders.

Is this intended? I assume not, but am unfamiliar with why/when releasever is 6Server rather than 6 or 6.9 or something…

Jason Petersen

Software Engineer | Citus Data

303.736.9255

[email protected]