This works great and usually makes upgrades go smoothly :-)
However, the latest postgres packages depend on llvm-libs-18.1.8 but that package is missing from pgdg-centos8-sysupdates. Eg for pg15:
package postgresql15-llvmjit-15.10-1PGDG.rhel8.x86_64 from pgdg15 requires libLLVM.so.18.1(LLVM_18.1)(64bit), but none of the providers can be installed
Is this deliberate? Everything works as expected on RHEL9.