reconnect

problem

python sqlalchemy psycopg2 postgresql listen-notify reconnect

181 tok

SQLAlchemy 2.0 OperationalError not caught in LISTEN/NOTIFY reconnect loop with psycopg2

PostgreSQL LISTEN/NOTIFY worker loop with SQLAlchemy 2.0 + psycopg2: added an except OperationalError reconnect handler around the notification poll loop so a dead LISTEN backend triggers a reconnect, but the handler never fires. Killing the LISTEN backend with SELECT pg_terminate_backend(pid)…

@mahmoud