Re: keep a connection alive

On Thursday 11 September 2008 09:36:42 am Federico Di Gregorio wrote:
> 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

Thanks for the information - it was helpful.  From reading the postgres list 
I'm guessing that I have router issue.  Apparently, routers notice that a 
connection is idle and disconnect.

-- 
John Fabiani