> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Friday, August 02, 2002 8:52 PM
> To: Tom Lane
> Cc: Mikheev, Vadim; richt(at)multera(dot)com; J. R. Nield; PostgreSQL Hacker
> Subject: Re: [HACKERS] PITR, checkpoint, and local relations
>
>
> Tom Lane wrote:
> > "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)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.
Our implementation of pg_copy did not archive to tape. This adds a lot of
complications so I thought just make a disk to disk copy and then the disk
copy could be archived to table at the users discretion.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>