> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Friday, August 02, 2002 8:06 PM
> To: Mikheev, Vadim
> Cc: richt(at)multera(dot)com; J. R. Nield; Bruce Momjian; PostgreSQL Hacker
> Subject: Re: [HACKERS] PITR, checkpoint, and local relations
>
>
> "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.
You want the log files necessary for recovering the database to be in the
backup copy -- don't you?
>
> regards, tom lane
>