BUG #17629: PostgreSQL repository not working on RHEL 8.6

The following bug has been logged on the website:

Bug reference:      17629
Logged by:          Aedan
Email address:      chipdankly@gmail.com
PostgreSQL version: 12.12
Operating system:   Red Hat Enterprise Linux 8.6
Description:

This URL does not exist.
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-8.6-x86_64/repodata/repomd.xml

This was the repository installed today 20221007 around 16:30 PST
https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

[root@vm ~]# dnf check-update
PostgreSQL common RPMs for RHEL / Rocky 8.6 - x86_64

                                233  B/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-8.6-x86_64/repodata/repomd.xml
(IP: 147.75.85.69)
Error: Failed to download metadata for repo 'pgdg-common': Cannot download
repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried

[root@vm ~]# cat /etc/redhat-release 
Red Hat Enterprise Linux release 8.6 (Ootpa)

[root@vm ~]# cat /etc/os-release 
NAME="Red Hat Enterprise Linux"
VERSION="8.6 (Ootpa)"
ID="rhel"
ID_LIKE="fedora"
VERSION_ID="8.6"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Red Hat Enterprise Linux 8.6 (Ootpa)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:8::baseos"
HOME_URL="https://www.redhat.com/"
DOCUMENTATION_URL="https://access.redhat.com/documentation/red_hat_enterprise_linux/8/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 8"
REDHAT_BUGZILLA_PRODUCT_VERSION=8.6
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="8.6"