page edit listener connection gets dropped
Pool is not suitable for long-running use-cases like a persistent event listener. Use an explicit connection wrapper instead.
[…] an object that wraps a connection to set up the listener and re-connect automatically if the underlying connection is lost. Like the pool connection holder only without a pool.
https://github.com/MagicStack/asyncpg/issues/283#issuecomment-384657037