Hi Sir
As per above discussion.....GOOD response from PostgreSQL
i am very happy to work on PostgreSQL.Super fast response only from postgres team regarding i asked any question related to postgres
regards
mahesh
On Fri, Mar 11, 2016 at 3:28 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 3/11/2016 1:50 AM, Durgamahesh Manne wrote:
Thanks for quick response .as per above conversation. for which parameter i can comment to resolve the issue & please specify the value of parameter sir
LOG: could not receive data from client: Connection reset by peer
your client is disconnecting without closing, thats all that error says, it doesn't say why this is happening, and without knowing why, there's no way to suggest a fix.
I suppose you could try setting tcp_keepalives_idle, if your connections are staying idle for a long time and your OS doesn't default to using tcp_keepalive, this could help.
I have no idea what a suitable value is, you didn't specify an operating system, a postgres version, what API your client is using, or if this is a localhost vs a LAN vs an internet connection, or really much of anything else..
btw, please reply to the list, not to me privately, thank you.