Re: Point in time recovery 20020822_01_pitr.patch

the fact that JR acknowledges issues that are yet to be resolved, and that
we are in the final week before beta ... I agree with Tom that this should
not go into v7.3, and be left for v7.4 ...

On Fri, 23 Aug 2002, Bruce Momjian wrote:

> J. R. Nield wrote:
> > Here's a patch to do point-in-time recovery against 7.3 head. Still to
> > be resolved in this patch:
> >
> > * CREATE/DROP database are still unlogged. dbcommands.c needs a
> > re-write to make that possible, since all the file and directory
> > operations will need to be logged, as will the data.
> >
> > * Is it really safe to do block-aligned reads to copy the database
> > files once (if) we remove backup blocks from the log? Should support be
> > added to go through the buffer manager?
> >
> >
> > New Files:
> > ./doc/FAQ_PITR
> > ./src/backend/commands/recoverycmds.c
> > ./src/include/commands/recoverycmds.h
>
> Here is quick overview of the patch. First, it starts with
> documentation about how the user interacts with the PITR system. Then
> it goes into a large chunk of code that logs and recovers from a variety
> of database changes that we don't currently log because they aren't
> needed for crash recovery but are required for PITR recovery. Next is a
> section that does the actual file backups for PITR, and finally, there
> is grammar code to support the new PITR commands.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>