Albrecht =?iso-8859-1?b?RHJl3w==?= <albrecht.dr...@arcor.de> writes:
> No messages are printed whilst the session is open. However, when I quit the
> session by typing “\q” /after/ entering the command above, the LOG message
> appears. It does not appear when I query tables from my_db exclusively,
> though, i.e. when I do not access the Foreign Table.
It finally occurred to me what is a likely explanation for why you're
seeing these messages but I don't when I test postgres_fdw locally:
probably, you are encrypting connections to the foreign server with SSL.
I can reproduce "could not receive data from client: Connection reset by
peer" if I kill -9 a psql client when it's using SSL, but not otherwise.
Anyway, it's clearly not very nice that postgres_fdw makes no attempt
to do a graceful shutdown of its remote connection. I don't know that
this rises to the level of a bug, exactly, but if somebody wanted to
send in a patch it'd probably get accepted.
regards, tom lane
