On Fri, Mar 11, 2016 at 3:22 AM, Durgamahesh Manne <maheshpostgres9@xxxxxxxxx> wrote: > 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. You could also be getting bitten by a network timeout here. If a connection sits idle for a while a firewall could be dropping the tcp connection. You can often work around this with lower tcp_keepalive timeout values. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
