Re: postgres client connection issue

Thanks Tom for acknowledge my mail. Below is the detail as you requested:

PG Version DBD::Pg : 2.10.3

TCP parameters in postgresql.conf configuration file:

#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;

# 0 selects the system default

#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;

# 0 selects the system default

#tcp_keepalives_count = 0 # TCP_KEEPCNT;

# 0 selects the system default

Postgers server logs:

2017-02-01 10:56:27 LOG: could not receive data from client: Connection reset by peer
2017-02-01 10:56:27 LOG: unexpected EOF on client connection
2017-02-01 10:57:19 LOG: could not receive data from client: Connection reset by peer
2017-02-01 10:57:19 LOG: unexpected EOF on client connection
2017-02-01 11:50:56 LOG: could not receive data from client: Connection reset by peer
2017-02-01 11:50:56 LOG: unexpected EOF on client connection
2017-02-01 12:11:48 LOG: could not receive data from client: Connection reset by peer
2017-02-01 12:11:48 LOG: unexpected EOF on client connection
2017-02-01 12:11:54 LOG: could not receive data from client: Connection reset by peer
2017-02-01 12:11:54 LOG: unexpected EOF on client connection
2017-02-01 12:32:42 LOG: could not receive data from client: Connection reset by peer
2017-02-01 12:32:42 LOG: unexpected EOF on client connection
2017-02-01 13:00:01 LOG: unexpected EOF on client connection
2017-02-01 13:00:01 LOG: unexpected EOF on client connection
2017-02-01 13:00:01 LOG: unexpected EOF on client connection
2017-02-01 13:30:01 LOG: unexpected EOF on client connection
2017-02-01 14:00:23 LOG: could not receive data from client: Connection reset by peer
2017-02-01 14:00:23 LOG: unexpected EOF on client connection
2017-02-01 14:10:02 LOG: unexpected EOF on client connection
2017-02-01 14:13:33 LOG: unexpected EOF on client connection
2017-02-01 14:13:36 LOG: unexpected EOF on client connection
2017-02-01 14:58:47 LOG: could not receive data from client: Connection reset by peer
2017-02-01 14:58:47 LOG: unexpected EOF on client connection
2017-02-01 15:01:36 LOG: could not receive data from client: Connection reset by peer
2017-02-01 15:01:36 LOG: unexpected EOF on client connection
2017-02-01 15:46:34 LOG: could not receive data from client: Connection reset by peer
2017-02-01 15:46:34 LOG: unexpected EOF on client connection
2017-02-01 15:48:02 LOG: could not receive data from client: Connection reset by peer
2017-02-01 15:48:02 LOG: unexpected EOF on client connection
2017-02-01 16:28:29 LOG: could not receive data from client: Connection reset by peer
2017-02-01 16:28:29 LOG: unexpected EOF on client connection
2017-02-01 16:40:04 LOG: could not receive data from client: Connection reset by peer
2017-02-01 16:40:04 LOG: unexpected EOF on client connection
2017-02-01 16:53:10 LOG: could not receive data from client: Connection reset by peer
2017-02-01 16:53:10 LOG: unexpected EOF on client connection
2017-02-01 16:56:48 LOG: could not receive data from client: Connection reset by peer
2017-02-01 16:56:48 LOG: unexpected EOF on client connection
2017-02-01 17:22:46 LOG: could not receive data from client: Connection reset by peer
2017-02-01 17:22:46 LOG: unexpected EOF on client connection
2017-02-01 17:38:44 LOG: could not receive data from client: Connection reset by peer
2017-02-01 17:38:44 LOG: unexpected EOF on client connection
2017-02-01 18:06:12 LOG: could not receive data from client: Connection reset by peer
2017-02-01 18:06:12 LOG: unexpected EOF on client connection
2017-02-01 18:18:00 LOG: could not receive data from client: Connection reset by peer
2017-02-01 18:18:00 LOG: unexpected EOF on client connection
2017-02-01 19:22:37 LOG: could not receive data from client: Connection reset by peer
2017-02-01 19:22:37 LOG: unexpected EOF on client connection
2017-02-01 20:57:29 LOG: could not receive data from client: Connection reset by peer
2017-02-01 20:57:29 LOG: unexpected EOF on client connection

Thanks & Regards,
Ranjeet Singh
Technology Analyst, Infosys Ltd
Electronics City, Bengaluru, Karnataka, India 560100
M: +91 9663748161
E: ranjeet_singh03(at)infosys(dot)com<mailto:ranjeet_singh03(at)infosys(dot)com>
Telstra Internet Direct (TID)
[Description: Description: Description: A NEW BTE_Email-signature_]<http://www.infosys.com/bte>

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, 3 February 2017 8:21 PM
To: Ranjeet Singh03 <Ranjeet_Singh03(at)infosys(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] postgres client connection issue

Ranjeet Singh03 <Ranjeet_Singh03(at)infosys(dot)com<mailto:Ranjeet_Singh03(at)infosys(dot)com>> writes:

> Below is the error logged in log file:

> DBD::Pg::st execute failed: server closed the connection unexpectedly

> This probably means the server terminated abnormally

What appears in the server's log when this happens? What PG version is it?

regards, tom lane