I'm seeing some intermittent issues with a client who is trying to connect to my Postgres server using the ODBC driver. I have about 15 customers who are able to connect without issue, but one seems to be having problems.
Here's what I'm seeing in the server's log file
xx.xxx.xxx.xxx(1351) 2009-04-10 21:08:20 EDT LOG: connection authorized: user=xxx database=xxx ... xx.xxx.xxx.xxx(1351) 2009-04-10 21:25:49 EDT LOG: could not receive data from client: Connection timed out xx.xxx.xxx.xxx(1351) 2009-04-10 21:25:49 EDT LOG: unexpected EOF on client connection xx.xxx.xxx.xxx(1089) 2009-04-10 21:25:49 EDT LOG: process 24517 acquired ShareLock on transaction 2282399 after 609040.428 ms xx.xxx.xxx.xxx(1351) 2009-04-10 21:25:49 EDT LOG: disconnection: session time: 0:17:30.678 user=xxx database=xxx host=xx.xxx.xxx.xxx port=xxxx
My best guess is that they are connecting, something is getting hung up, and when they try to reconnect, they aren't able to do so.
I'm somewhat stuck as to where to start looking for a solution. Can anyone assist?