On 2025/02/18 23:44, Sagar Shedge wrote:
Dear Hackers, I want to propose to extend existing postgres_fdw_get_connections functionality to return remote server backend pid. Using postgres_fdw extension, backend can establish connections to remote postgres servers. Recently we added functionality to get connection status which can help users to detect closed connections immediately. But currently there is no way to get a remote backend PID for these connections.
I assume you're planning to extend postgres_fdw_get_connections() to also return the result of PQbackendPID(entry->conn). However, the patch you attached doesn't seem to include that change. Did you attach the wrong patch? Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION
