Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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.A. Oude Kotte" <marc(at)solcon(dot)nl>, pgsql-general(at)postgresql(dot)org
- Subject: Re: Rollback using WAL files?
- Date: Fri, 26 Jan 2007 12:45:24 -0500
- Message-id: <26103(dot)1169833524(at)sss(dot)pgh(dot)pa(dot)us>
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
- References:
- Rollback using WAL files?
- From: M.A. Oude Kotte
- Re: Rollback using WAL files?
- From: Florian Weimer
- Rollback using WAL files?
- Prev by Date: Re: Can you specify the pg_xlog location from a config file?
- Next by Date: Re: Problem with result ordering
- Previous by thread: Re: Rollback using WAL files?
- Next by thread: Re: Rollback using WAL files?
- Indexes: