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

Re: Keep-alive?

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Keep-alive?
Date: 2003-10-10 13:40:10
Message-ID: 3F86B6BA.1010309@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
Dave Page wrote:

>
>Anyway, the reason I posted the patch was to gather ideas and feedback,
>not to propose it as a final solution (as your initial comments indicate
>you thought). I don't see any way to implement this cleanly at this
>layer now so unless you or anyone else has any bright ideas I'll scrub
>it from the todo list as unworkable, and move one...
>  
>

pgAdmin3 is just another app, concerning the database connection. So if 
pgAdmin3 suffers from broken links, any other libpq app would too. It 
would make sense to implement this in libpq.
If we wanted to implement this in pgAdmin3, we'd need a global keepalive 
thread, scanning all connections if a keep alive query is needed, 
interlocking with a semaphor to prevent interference with wanted 
queries. This thread also could silently handle reconnects.


Regards,
Andreas



In response to

pgadmin-support by date

Next:From: Raphaƫl EnriciDate: 2003-10-10 14:49:06
Subject: Re: Cannot compile
Previous:From: Dave PageDate: 2003-10-10 13:08:19
Subject: Re: Keep-alive?

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