> -----Original Message----- > From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] > Sent: 09 October 2003 13:31 > To: Dave Page > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > 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.
Heartbeat.patch
Description: Heartbeat.patch
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
