From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Recovery Features |
Date: | 2004-07-06 07:05:06 |
Message-ID: | 1089097505.17493.155.camel@stromboli |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB SD | 2004-07-06 07:38:47 | Re: Point in Time Recovery |
Previous Message | Dennis Bjorklund | 2004-07-06 06:15:14 | Re: Nested Transactions, Abort All |