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 Vladimir Svedov
Subject Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer
Date
Msg-id CADqDLE9-0GzPrk6XMmfU-ySos_1s=SiiquTH=wa=k6cYMmoFfg@mail.gmail.com
Whole thread Raw
In response to Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view
No, I select from it OK.
The bug(?) is that when I do it in oppened psql session it produces no log, and when I run same select as psql -c "SELECT..." it gives the above

2016-11-22 20:18 GMT+00:00 Robert Haas <robertmhaas@gmail.com>:
On Tue, Nov 22, 2016 at 5:05 AM, Vladimir Svedov <vodevsh@gmail.com> wrote:
> Hi,
> Sorry - tried to reproduce on other machine and gather all statements. And
> failed
> Installed 9.3 (which has those symptoms) and still can't reproduce.
> Must be platform specific, not version

Probably the foreign server isn't configured properly, and points to a
host/port to that resets the connection when you attempt to connect to
it.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Parallel bitmap heap scan
Next
From: Andres Freund
Date:
Subject: Re: Performance degradation in Bitmapscan (commit 75ae538bc3168bf44475240d4e0487ee2f3bb376)