| From: | Vladimir Svedov <vodevsh(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | postgres 9.3 postgres_fdw ::LOG: could not receive data from client: Connection reset by peer |
| Date: | 2016-11-21 14:32:20 |
| Message-ID: | CADqDLE_m-fSMRjHec6aT7LfkVs9zHy3xD6o54DOTf2K3+1K3oA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
I can't set logging lower and yet this message distracts. Please share any
idea how to set up env to avoid generating this message?.. I feel I'm
missing something obvious, but can't see what.
PS. I tried running -f file instead of -c "SQL". Of course it did not
change a thing. And of course I tried putting \q to file with same result...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tobias Bussmann | 2016-11-21 15:11:51 | Re: Parallel execution and prepared statements |
| Previous Message | Stephen Frost | 2016-11-21 13:59:18 | Re: Improvements in psql hooks for variables |