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