The PosgreSQL v14.23 RPM seems to be missing in the generic RHEL 9 repos:
MISSING - https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-8-x86_64/MISSING - https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-9-x86_64/
EXISTS - https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-8.10-x86_64/EXISTS - https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-9.6-x86_64/EXISTS - https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-9.7-x86_64/
Regards,Greg.