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