psycopg3 AsyncConnection connection notifies generator health check
I have a long-running process (possibly months) that listens for notifications on a database connection using conn.notifies()
(see psycopg3 documentation). The documentation doesn’t specify the expected behavior if the listening connection becomes unresponsive/corrupt, so I believe I need to perform health checks myself.