Re: Point in time recovery: recreating relation files

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Point in time recovery: recreating relation files
Дата
Msg-id 4472.1015477207@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Point in time recovery: recreating relation files  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Ответы Re: Point in time recovery: recreating relation files  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Список pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> I'm wondering where we could record the LSN when creating or dropping
> tables.
>> 
>> Um, why would that matter?

> In my understanding to prevent redo-ing two or more times while in the
> recovery process, we need to compare LSN in the object against the LSN
> in the WAL log.

But undo/redo checking on file creation or deletion is trivial: either
the kernel has the file or it doesn't.  We do not need any other check
AFAICS.
        regards, tom lane


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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Point in time recovery: recreating relation files
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: date formatting and tab-complete patch