On 2/24/19 2:25 AM, Lukáš Sobotka wrote:
> Thanks for quick answer. I am feeling a little embarrassed that I did
> not find this before... The thread definitely helped me to understand more.
>
> When I execute query with foreign tables, the connection is created
> (according pg_stat_activity). The question is what I should do for
> ending the connection. I can get PID of connection and force to end it
Not sure. In the original thread the OP was calling conn.close() from
inside a Python script and still seeing the message. The only way they
could prevent it was to disable SSL. From what I gather this is down in
the internals of the code and needs a patch to fix. Someone with more
knowledge of this will need to comment further.
> by pg_terminate_backend, but that is not "clean way".
>
> Unfortunately I can not disable SSL encryption as it is mentioned in the
> thread. But it is interesting for me, that the log message (resetting by
> peer) is created only in encrypted connection, because in both way the
> connection stayed defined in pg_stat_activity after query on foreign table.
>
> so 23. 2. 2019 v 22:48 odesílatel Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> napsal:
--
Adrian Klaver
adrian.klaver@aklaver.com