Re: Rollback using WAL files?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Rollback using WAL files?
Дата
Msg-id 26103.1169833524@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Rollback using WAL files?  (Florian Weimer <fweimer@bfk.de>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can you specify the pg_xlog location from a config file?
Следующее
От: Thorsten Körner
Дата:
Сообщение: Re: Problem with result ordering