Skip site navigation (1) Skip section navigation (2)

Re: Keep-alive?

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Adam H(dot) Pendleton" <fmonkey(at)fmonkey(dot)net>
Cc: <Michiel_Lange(at)actuera(dot)nl>, <mark(at)nsa(dot)co(dot)il>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Keep-alive?
Date: 2003-10-09 20:35:04
Message-ID: 03AF4E498C591348A42FC93DEA9661B84C5AD8@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: Adam H. Pendleton [mailto:fmonkey(at)fmonkey(dot)net] 
> Sent: 09 October 2003 13:31
> To: Dave Page
> Cc: Michiel_Lange(at)actuera(dot)nl; mark(at)nsa(dot)co(dot)il; 
> pgadmin-support(at)postgresql(dot)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.

Attachment: Heartbeat.patch
Description: application/octet-stream (9.0 KB)

Responses

pgadmin-support by date

Next:From: Troels ArvinDate: 2003-10-09 21:09:12
Subject: Cannot compile
Previous:From: Adam H. PendletonDate: 2003-10-09 12:31:13
Subject: Re: Keep-alive?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group