postgres_fdw: Add function to list cached connections to foreign servers

Enterprise / PostgreSQL - Fujii Masao [postgresql.org] - 18 January 2021 06:11 UTC

This commit adds function postgres_fdw_get_connections() to return the foreign server names of all the open connections that postgres_fdw established from the local session to the foreign servers. This function also returns whether each connection is valid or not.

This function is useful when checking all the open foreign server connections. If we found some connection to drop, from the result of function, probably we can explicitly close them by the function that upcoming commit will add.

This commit bumps the version of postgres_fdw to 1.1 since it adds new function.

Author: Bharath Rupireddy, tweaked by Fujii Masao

708d165ddb postgres_fdw: Add function to list cached connections to foreign servers.
contrib/postgres_fdw/Makefile | 2 +-
contrib/postgres_fdw/connection.c | 135 ++++++++++++++++++++++++
contrib/postgres_fdw/expected/postgres_fdw.out | 61 ++++++++++-
contrib/postgres_fdw/postgres_fdw--1.0--1.1.sql | 10 ++
contrib/postgres_fdw/postgres_fdw.control | 2 +-
contrib/postgres_fdw/sql/postgres_fdw.sql | 27 +++++
doc/src/sgml/postgres-fdw.sgml | 32 ++++++
7 files changed, 266 insertions(+), 3 deletions(-)

Upstream: git.postgresql.org


  • Share