Re: WAL and pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WAL and pg_dump
Дата
Msg-id 1659.1135294361@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WAL and pg_dump  (Mike C <smith.not.western@gmail.com>)
Список pgsql-admin
Mike C <smith.not.western@gmail.com> writes:
> I guess if pg_dump was modified to record the last complete transaction id
> (in archive format maybe) then the WAL files could be used?

No.  pg_dump output and WAL files are at two utterly different levels of
abstraction --- the WAL files describe the exact placement of tuples
within tables and indexes, to mention just one example.  There's no hope
of using pg_dump output to reproduce the state of a database exactly
enough that you could apply WAL files to it.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Create Index Locking Question
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: lo_ functions