Thread: [GENERAL] postgres_fdw & could not receive data from client:Connection reset by peer

[GENERAL] postgres_fdw & could not receive data from client:Connection reset by peer

From
Adam Brusselback
Date:
Hey all, first off...
Postgres version: 10.1
OS: Debian 9.0

So I have a database called: authentication
It stores my user table for my application.  I have it separated from
the main database of my application to allow the same account to be
used by multiple instances of my application.

From a connection to my main database, I need to be able to query this
table as if it existed in my main database, so I set up a postgres_fdw
connection to it.  This works well, and I have no issues with the
setup functionally.  I can have multiple instances of my main
application database (test, dev, prod), all pointed to the same
"authentication" database, and everything works. My users can keep
logging into the application with the same credentials no matter which
environment they go into.

The only thing I have seen, is pretty much any query which references
the foreign user table (and connects to the auth db's user table) will
put a line in my log file like so:

2017-11-22 14:27:09.846 UTC [17388] authentication@authentication LOG:could not receive data from client: Connection
resetby peer
 

I was wondering if this was normal behavior, or if i'm doing something
wrong to cause this?  It happens no matter if my queries come from
pgadmin, psql, or jdbc.

Any info would be greatly appreciated.
Thanks,
-Adam


Just bumping this because I posted it right before Thanksgiving and it was very easy to overlook. Sorry if this is bad etiquette for the list... Just let me know if it is and I won't do it in the future.