On Fri, 2021-01-22 at 16:03 +1100, Steve Baldwin wrote:
> If I have made a query on a foreign table (using postgres_fdw),
> it establishes a connection automatically. Is there any way to
> disconnect that fdw connection without disconnecting the session
> that instigated it?
No.
From PostgreSQL v14 on, there is the "idle_session_timeout" that you
could set on the server to close such sessions. postgresql_fdw will
silently re-establish such broken connections. You could set this
parameter in the foreign server definition.
But this is a strange request: why would you want to close such
connections before the database session ends?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com