pgcli @4.0.1 [python310, [+]python311, python38, python39]: crashes on start with psycopg import error

[ozeidan (Omar Zeidan)]

When I start pgcli, the program crashes:

Traceback (most recent call last):
  File "/Users/<user>/macports/bin/pgcli", line 5, in <module>
    from pgcli.main import cli
  File "/Users/<user>/macports/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/pgcli/main.py", line 2, in <module>
    from pgspecial.namedqueries import NamedQueries
  File "/Users/<user>/macports/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/pgspecial/__init__.py", line 12, in <module>
    from . import dbcommands
  File "/Users/<user>/macports/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/pgspecial/dbcommands.py", line 7, in <module>
    from psycopg.sql import SQL
  File "/Users/<user>/macports/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/psycopg/__init__.py", line 9, in <module>
    from . import pq  # noqa: F401 import early to stabilize side effects
    ^^^^^^^^^^^^^^^^
  File "/Users/<user>/macports/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/psycopg/pq/__init__.py", line 114, in <module>
    import_from_libpq()
  File "/Users/<user>/macports/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/psycopg/pq/__init__.py", line 106, in import_from_libpq
    raise ImportError(
ImportError: no pq wrapper available.
Attempts made:
- couldn't import psycopg 'c' implementation: No module named 'psycopg_c'
- couldn't import psycopg 'binary' implementation: No module named 'psycopg_binary'
- couldn't import psycopg 'python' implementation: libpq library not found