[Pgpool-general] Online recovery timeouts

[Tevis Money]

Tatsuo Ishii wrote:
>> Back in January, there was a discussion on online recovery during load 
>> (http://pgfoundry.org/pipermail/pgpool-general/2010-January/002445.html). 
>> While the originator seemed to solve their problem, I'm still 
>> experiencing a similar problem with programs (such as pgadmin) which 
>> maintain a persistent connection and prevent pgpool from performing 
>> recovery.
>>     
>
> Just out of curiosity, why don't you just stop pgadmin if you go into
> online recovery?
>
>   
In this case I was mostly providing an example (as I recall, you had 
asked for confirmation in that original thread as to whether pgadmin 
caused the issue). In our particular instance, we're also having the 
issue with a Tomcat server which seems to be causing the same problem 
even though the connection is supposedly idle. Quitting pgadmin is no 
problem for us, but stopping our Tomcat server is a bit more problematic.

>> Are their any options for having pgpool force a client to disconnect, 
>> regardless of what the client is doing?
>>     
>
> Currently no. A patch has been proposed for this. I have looked into
> the patch and came to the conclusion that same idea could be
> implemented in more "natural" way. Of course this does not make the
> original idea less valuable at all. Thanks for this.
>
> Pgpool development team are now busy for working on releasing minor
> version up of pgpool-II 2.2 and 2.3 tree. We expect that this will be
> done within one or two weeks and after that we will start 2.4
> development which will include the functionality mentioned above.
>   
That's great to hear. This is a fantastic piece of software, and thank 
you to you and the entire pgpool team for your hard work.