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
Список 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 по дате отправления:

Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.