| From: | "Hou, Zhijie" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com> |
|---|---|
| To: | Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Subject: | RE: FDW connections |
| Date: | 2021-01-22 08:31:53 |
| Message-ID: | bcc96d952b1448d2af62a0609f832bb6@G08CNEXMBPEKD05.g08.fujitsu.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > 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.
Best regards,
houzj
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benedict Holland | 2021-01-22 13:17:03 | Re: Copy & Re-copy of DB |
| Previous Message | Laurenz Albe | 2021-01-22 08:17:06 | Re: FDW connections |