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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer
Дата
Msg-id CAMkU=1w5p6GCEQFvcN_KcDXr2qVb4BhRt5SkH6ehBYoS1uD8bg@mail.gmail.com
обсуждение исходный текст
Ответ на postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer  (Vladimir Svedov <vodevsh@gmail.com>)
Ответы Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer  (Vladimir Svedov <vodevsh@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "Karl O. Pinc"
Дата:
Сообщение: Re: Patch to implement pg_current_logfile() function
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [bugfix] commit timestamps ERROR on lookup of FrozenTransactionId