Re: Point in time recovery: recreating relation files

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Point in time recovery: recreating relation files
Дата
Msg-id 20020307092200J.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
> 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.

> If you try to do it as you suggest above, then you will erroneously
> recreate files that have been dropped.

Yes, but I think we need to compare log's LSN and tables LSN.
--
Tatsuo Ishii


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

Предыдущее
От: Greg Copeland
Дата:
Сообщение: Re: Bad Build
Следующее
От: Eric Scroger
Дата:
Сообщение: [Fwd: Re: [JDBC] A result was returned by the statement, when none was expected]