> > 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? > Hi There are two new functions being reviewed called: postgres_fdw_disconnect() postgres_fdw_disconnect_all() These function may solve your problem, If you are interested in that, you can take a look at [1]. The functions have not been committed yet, it may can be used in PG14. [1] https://www.postgresql.org/message-id/CALj2ACVcpU%3DwB7G%3DzT8msVHvPs0-y0BbviupiT%2Bf3--bGYaOMA%40mail.gmail.com Best regards, houzj
