How are Postgres server restarts handled?

Hi guys,

We are using asyncpg in a web application.

Upon starting the web server, we do the following two things:

1. db = asyncpg.create_pool to create the connection pool for the application's DB connections.
2. conn = await db.pool.acquire(); await conn.add_listener('foo', _callback) to register long-lived listeners to catch and handle NOTIFY events from the DB.

Recently I restarted the Postgres server and noticed something interesting. First, connections to the DB using the db pool object saw no interruption and were still able to connect to the DB server despite it having a new PID (since the process had been restarted).

However, the conn the application relied on to receive async notifications from the server was dead/closed and so the application logic dependent upon receiving those notifications was not functioning. (This is how I reproduced this issue and discovered the cause to have been a PG server restart.)

• Why is the pool unaffected by restart? It makes sense the connection instance is dead since the socket is closed after restarting the server, but I'm a bit surprised the pool is not affected.
• I suppose the best strategy for checking for dead DB connections would be to simply check conn.is_closed periodically - or, is there some "on connection close" callback I can define to retry/reopen a connection (since obtaining new connections from the pool still works after restart)?

首先查看报告中描述的 asyncpg.create_pool、pool.acquire、add_listener 和 conn.is_closed 入口点，以及服务器重启期间 PostgreSQL NOTIFY 的行为。确定池化连接和长期运行的监听器应如何运行，并记录检测和恢复已关闭监听器连接的受支持方式。