Jeff Lanzarotta wrote:
Hello, I am writing an application that reads information from my PostgreSQL database. If I cause the program to crash and the program ends without gracefully disconnecting from the database, there is an open connection still left in the database. How does the PostgreSQL server handle clients that disconnect ungracefully? Will the server automatically clean up this connection that really is not there?
Worst case is that the tcp/ip connection is never cleared down. That means the connection will sit there until your tcp/ip stack clears it down. I *think* that's an hour on linux.
-- Richard Huxton Archonet Ltd
