Re: Point in time recovery: recreating relation files - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Point in time recovery: recreating relation files
Date
Msg-id 20020307135638A.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Point in time recovery: recreating relation files  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Point in time recovery: recreating relation files  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: date formatting and tab-complete patch
Next
From: Tom Lane
Date:
Subject: Re: Point in time recovery: recreating relation files