Re: Rollback using WAL files?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Florian Weimer <fweimer(at)bfk(dot)de>
Cc: "M(dot)A(dot) Oude Kotte" <marc(at)solcon(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: Rollback using WAL files?
Date: 2007-01-26 17:45:24
Message-ID: 26103.1169833524@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Florian Weimer <fweimer(at)bfk(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thorsten Körner 2007-01-26 17:53:26 Re: Problem with result ordering
Previous Message Tom Lane 2007-01-26 17:31:48 Re: Can you specify the pg_xlog location from a config file?