Re: Recovery control functions

On Sat, Jan 15, 2011 at 12:17, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Sat, 2011-01-15 at 20:11 +0900, Fujii Masao wrote:
>> On Fri, Jan 14, 2011 at 9:00 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>> >> How hard would it be to have a pg_xlog_replay_until(<xlog location or
>> >> timestamp>), to have it resume recovery up to that point and then
>> >> pause again?
>> >
>> > You can already do that for timestamps.
>>
>> You mean using recovery_target_time and pause_at_recovery_target?
>> The problem is that we cannot continue recovery after the pause
>> by them. If we resume recovery after the pause, recovery ends
>> immediately.
>
> Shutdown while paused, alter parameter, restart.

That's something I'd very much like to avoid - being able to say
continue-until using the function would be very nice. Consider for
example doing this from pgadmin.

So I'm back to my original question which is, how much work would this
be? I don't know my way around that part so I can't estimate, and
what's there so far is certainly a lot better than nothing, but if
it's not a huge amount of work it would be a great improvement.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/