Re: Rollback using WAL files? - Mailing list pgsql-general

From Tom Lane
Subject Re: Rollback using WAL files?
Date
Msg-id 26103.1169833524@sss.pgh.pa.us
Whole thread Raw
In response to Re: Rollback using WAL files?  (Florian Weimer <fweimer@bfk.de>)
List pgsql-general
Florian Weimer <fweimer@bfk.de> writes:
> In theory, this should be possible (especially if you haven't switched
> off full page writes).

Not really --- the WAL records are not designed to carry full
information about the preceding state of the page, so you can't use them
to undo.  (Example: a DELETE record says which tuple was deleted, but
not what was in it.)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can you specify the pg_xlog location from a config file?
Next
From: Thorsten Körner
Date:
Subject: Re: Problem with result ordering