python-psycopg2 fails to build with Python 3.11.0a2.

+ /usr/bin/python3 -c 'import tests; tests.unittest.main(defaultTest='\''tests.test_suite'\'')' --verbose
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/builddir/build/BUILD/psycopg2-2.9.1/tests/__init__.py", line 35, in <module>
    from . import test_async
    ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/builddir/build/BUILD/psycopg2-2.9.1/tests/test_async.py", line 31, in <module>
    import psycopg2
    ^^^^^^^^^^^^^^^
  File "/builddir/build/BUILDROOT/python-psycopg2-2.9.1-1.fc36.x86_64/usr/lib64/python3.11/site-packages/psycopg2/__init__.py", line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SystemError: initialization of _psycopg raised unreported exception

For the build logs, see:
https://copr-be.cloud.fedoraproject.org/results/@python/python3.11/fedora-rawhide-x86_64/02940391-python-psycopg2/

For all our attempts to build python-psycopg2 with Python 3.11, see:
https://copr.fedorainfracloud.org/coprs/g/python/python3.11/package/python-psycopg2/

Testing and mass rebuild of packages is happening in copr. You can follow these instructions to test locally in mock if your package builds with Python 3.11:
https://copr.fedorainfracloud.org/coprs/g/python/python3.11/

Let us know here if you have any questions.

Python 3.11 is planned to be included in Fedora 37. To make that update smoother, we're building Fedora packages with all pre-releases of Python 3.11.
A build failure prevents us from testing all dependent packages (transitive [Build]Requires), so if this package is required a lot, it's important for us to get it fixed soon.
We'd appreciate help from the people who know this package best, but if you don't want to work on this now, let us know so we can try to work around it on our side.