Re: set_ps_display during recovery

Simon Riggs <simon@2ndquadrant.com> writes:
> On Sat, 2007-09-29 at 14:34 -0400, Tom Lane wrote:
>> Hmm, not right there, because we don't know that the file actually
>> exists yet.  Applied with modifications ...

> Double hmmm, that means when we are waiting for file X in pg_standby the
> ps display will still show "recovering X-1". I'd prefer to set ps before
> the call to RestoreArchivedFile(), since that is where the wait occurs.
> I got that wrong myself.

Well, if you think that's an important time component --- which it could
be in archive situations, I guess --- there should be a separate PS
display state for it.  Perhaps "fetching XXX" vs "restoring XXX"?

            regards, tom lane