Re: Simple, safe hot backup and recovery

Hi Sano-san,

On Fri, Jun 5, 2009 at 7:02 PM, Yoshinori Sano<yoshinori(dot)sano(at)gmail(dot)com> wrote:
>> In v8.4, pg_stop_backup waits until all WAL files used during backup
>> are archived.
>> So, "sleep" is already unnecessary for standalone hot backup.
>
> Oh, it's a great news!  We don't need to use the unsafe approach (the
> sleep command) anymore if we use v8.4, do we?

Yes in upcoming v8.4. Of course, in or before v8.3, you still need to
make up the safe mechanism. For that, XLogArchiveIsBusy() function
which was added in v8.4 may be a good reference to you.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center