Re: keep a connection alive

Il giorno gio, 11/09/2008 alle 08.33 -0700, johnf ha scritto:
> 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).

psycopg uses libpq and does not handle that kind of problem at all. If
for some reason (TCP, PostgreSQL server configuration) the connection is
closed/dropped psycopg will just raise an exception on your next query.

federico

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                [email protected]
INIT.D Developer                                           fog-NGVKUo/i/[email protected]
                             Domani si vede domani. -- Alessandra O'Hara

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEABECAAYFAkjJSRoACgkQvcCgrgZGjevMuACdGtqNTBg/FbVgkREURiqsjOxD
AmQAoNV/sU3OFp9rUm8aaOQ066IOVp8p
=Pg4x
-----END PGP SIGNATURE-----