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 20020307141110A.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
> > 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.

Are you saying that the table creation log record would contain a
relfilenode? I'm not sure the relfilenode is same before and after the
recovery if we consider the point time recovery.
--
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: Bad Build