Re: PITR, checkpoint, and local relations

Tom Lane wrote:
> "Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> >> It should be sufficient to force a checkpoint when you
> >> start and when you're done --- altering normal operation in between is
> >> a bad design.
> 
> > But you have to prevent log files reusing while you copy data files.
> 
> No, I don't think so.  If you are using PITR then you presumably have
> some process responsible for archiving off log files on a continuous
> basis.  The backup process should leave that normal operational behavior
> in place, not muck with it.

But what if you normally continuous LOG to tape, and now you want to
backup to tape.  You can't use the same tape drive for both operations.
Is that typical?  I know sites that had only one tape drive that did
that.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026