vault fails to install in lunar

When installing the charm from latest/edge on lunar we see the following error on unit-vault-X.log
###

2023-07-04 16:05:22 ERROR unit.vault/0.juju-log server.go:316 Hook error:
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-vault-0/.venv/lib/python3.11/site-packages/charms/reactive/__init__.py", line 71, in main
    bus.discover()
  File "/var/lib/juju/agents/unit-vault-0/.venv/lib/python3.11/site-packages/charms/reactive/bus.py", line 426, in discover
    _register_handlers_from_file(search_path, filepath)
  File "/var/lib/juju/agents/unit-vault-0/.venv/lib/python3.11/site-packages/charms/reactive/bus.py", line 466, in _register_handlers_from_file
    _load_module(root, filepath)
  File "/var/lib/juju/agents/unit-vault-0/.venv/lib/python3.11/site-packages/charms/reactive/bus.py", line 444, in _load_module
    return importlib.import_module(package + module)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.11/importlib/__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<frozen importlib._bootstrap>", line 1206, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1178, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1149, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 690, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 940, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "/var/lib/juju/agents/unit-vault-0/charm/reactive/vault_handlers.py", line 3, in <module>
    import psycopg2
  File "/var/lib/juju/agents/unit-vault-0/.venv/lib/python3.11/site-packages/psycopg2/__init__.py", line 51, in <module>
    from psycopg2._psycopg import ( # noqa
SystemError: initialization of _psycopg raised unreported exception

###

This is due to psycopg2 being pinned to 2.8.6, and it does not support python 3.11.
Unpinning the package and installing latest 2.9.6 works fine, seems that we need to pin to at least >2.9.5 [0] since that is what introduced python 3.11 support [1]

[0] https://www.psycopg.org/docs/news.html#what-s-new-in-psycopg-2-9-5
[1] https://github.com/psycopg/psycopg/issues/424