Re: Point in time recovery 20020822_01_pitr.patch

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