keep a connection alive

johnf <jfabiani-rLSQ/[email protected]> Thu, 11 Sep 2008 08:33:13 -0700

Newsgroups	gmane.comp.python.db.psycopg.devel
Message-ID	<[email protected]>

Hi,
I created a program that uses psycopg2 to connect remotely to a postgres 8.3.1  
database (server is on a linux box).  On my local linux system I can keep the 
connection forever.  However, on the clients XP windows it appears to timeout 
during idle time.  It has been suggested that maybe the tcp_keepalives 
options need to be set on the server.  Can someone here enlighten me 
regarding how psycopg2 handles the problem on windows.  And what I might want 
to do on the server side if anything.  The setting is at default (as it came 
from openSUSE 11).

The windows version of psycopg2 is 2.0.6.b1.  My local linux version is 2.0.7
-- 
John Fabiani