Search Postgresql Archives

Re: Regarding connection drops for every few minutes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux