Hi Scott, > Most likely what is happening is that you have a firewall between your > app and your db server that is closing idle connections after x minutes.
Thanks for your comment. I hate to be disagreeable, but the app and postgres are running on the same computer. The app is a java program using jdbc to issue postgres commands. However, I see the same message via psql (on the same machine). Tena Sakai [EMAIL PROTECTED] -----Original Message----- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Fri 11/9/2007 2:11 PM To: Tena Sakai Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] idle in transaction...unexpected EOF on client connection On Nov 9, 2007 3:58 PM, Tena Sakai <[EMAIL PROTECTED]> wrote: > > Hi Everybody, > > I see in serverlog many entries that read: > <gadb 2007-11-09 13:13:47 PST idle in transaction>LOG: unexpected EOF on > client connection > <gadb 2007-11-09 13:23:08 PST idle in transaction>LOG: unexpected EOF on > client connection > <gadb 2007-11-09 13:23:44 PST idle in transaction>LOG: unexpected EOF on > client connection > <gadb 2007-11-09 13:25:42 PST idle in transaction>LOG: unexpected EOF on > client connection > > This occurs regularly and frequently and I am > wondering if it is indicative of any underlying > issue(s). Would you please let me know what > you know? Most likely what is happening is that you have a firewall between your app and your db server that is closing idle connections after x minutes. Could be other things, like crashing clients, etc... Hard to say without more evidence.
