Re: Recovery Features

On Tue, 2004-07-06 at 00:30, Mike Mascari wrote:
> Simon Riggs wrote:
>
> > On Mon, 2004-07-05 at 23:40, Mike Mascari wrote:
> >
> > hmmm...not sure I know what you mean.
> >
> > It is very-very-close-to-impossible to edit the transaction logs
> > manually, unless some form of special-format editor were written for the
> > purpose.
> >
> > Is it clear that the PITR features are completely different from
> > pg_dump? (Which would allow a manual edit and recover). The xlogs are
> > binary files that refer to all changes to all tables in a cluster
> > ordered by time, rather than by table.
>
> What I meant by hand-restore was
>
> 1. A total backup occurrs on Monday morning
>
> 2. Transactions occur on Monday, Tuesday and Wednesday, with PITR
> archiving enabled
>
> 3. Intern deletes everyting from obscure_table on Thursday afternoon
> and wants to restore it as it was on Thursday morning
>
> 4. On some other machine, the total backup is restored into a new
> cluster, the transaction logs replayed to that point-in-time where
> intern deleted everything from obscure_table
>
> 5. The table is dumped manually and restored in the production
> database, because it is known that this table has no logicial
> implications for the consisetency of other tables.
>
> That's what I meant by hand-restore.
>

Excellent. Thanks very much for the clarification. I was worried that I
had misrepresented the functionality, but you have it spot on.

The scenario you describe is going to be possible now...

Best Regards, Simon Riggs