Rough estimates, sometime next week or the week after for Rocky 9.7 and 10.1 as per here: Rocky 9.7, Rocky 10.1 and EPEL
I have similar issues for example on Fedora. When I update to a new Fedora release, I have to wait for a new PGAdmin release to be made as it’s always behind by a few weeks. Here is the other way, since RHEL has released 10.1, then Postgres are already ready for it.
Basically currently, the Postgres situation is exactly the same as EPEL or any other third party repository that has already rebased to 9.7 or 10.1 dependencies and resolved when Rocky releases.