Re: Point in time recovery: recreating relation files

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Point in time recovery: recreating relation files
Дата
Msg-id 20020307135638A.t-ishii@sra.co.jp
обсуждение исходный текст
Ответ на Re: Point in time recovery: recreating relation files  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Point in time recovery: recreating relation files  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> >> No, that's wrong.  The missing ingredient is that the WAL log should
> >> explicitly log table creations.  (And also table drops.)  If you look
> >> you will find some comments showing the places where code is missing.
> 
> > 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.
--
Tatsuo Ishii


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

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