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.
Mike Mascari
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
