Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer

On Mon, Nov 21, 2016 at 6:32 AM, Vladimir Svedov <vodevsh(at)gmail(dot)com> wrote:

> Hi,
> I have this question. Looked for a help on http://dba.stackexchange.com/
> No success.
> Maybe you can answer?..
> Thank you in advance
>
>
> "FOREIGN_TABLE" created with postgres_fdw. LOCAL_TABLE is just a local
> table...
>
> Symptoms:
>
> 1. I run in psql query SELECT * from FOREIGN_TABLE. No log generated
> 2. I run in bash psql -c "SELECT * from LOCAL_TABLE". No log generated
> 3. I run in bash psql -c "SELECT * from FOREIGN_TABLE". ::LOG: could
> not receive data from client: Connection reset by peer generated in
> postgres log
>
>
Which server log file is this generated in, the local or the foreign?
Whichever it is, is there an entry in the logfile for the other server
which seems to match up to this one? That may have more useful details.

Cheers,

Jeff