> -----Original Message-----
> From: Adam H. Pendleton [mailto:fmonkey@fmonkey.net]
> Sent: 09 October 2003 13:31
> To: Dave Page
> Cc: Michiel_Lange@actuera.nl; mark@nsa.co.il;
> pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Keep-alive?
>
> Dave Page wrote:
>
> >2) Implement SQL level keep alives. This could a be simple SELECT
> >version() query that is executed automatically after n seconds of
> >inactivity.
> >
> >
> >
> This is what I had in mind, an application (i.e., layer 7)
> level keep-alive.
OK, just fiddling around here - attached is a patch that implements a
heartbeat on the master connection to each server. Currently it beats
every 5 seconds, though this would be made configurable/disable-able.
It doesn't actually do much other than throw an error message if it gets
an unexpected response.
Thoughts, comments?
Regards, Dave.