Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer
Date
Msg-id CAMkU=1w5p6GCEQFvcN_KcDXr2qVb4BhRt5SkH6ehBYoS1uD8bg@mail.gmail.com
Whole thread Raw
In response to postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer  (Vladimir Svedov <vodevsh@gmail.com>)
Responses Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer
List pgsql-hackers
Tree view
On Mon, Nov 21, 2016 at 6:32 AM, Vladimir Svedov <vodevsh@gmail.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

pgsql-hackers by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Patch to implement pg_current_logfile() function
Next
From: Andres Freund
Date:
Subject: Re: [bugfix] commit timestamps ERROR on lookup of FrozenTransactionId