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

From Tom Lane
Subject Re: Point in time recovery: recreating relation files
Date
Msg-id 8107.1015478991@sss.pgh.pa.us
Whole thread Raw
In response to Re: Point in time recovery: recreating relation files  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: Point in time recovery: recreating relation files  (Marc Munro <marc@bloodnok.com>)
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>> 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?

Sure.  What else would it contain?

> I'm not sure the relfilenode is same before and after the
> recovery if we consider the point time recovery.

Considering that all the WAL entries concerning updates to the table
will name it by relfilenode, we'd better be prepared to ensure that
the relfilenode doesn't change over recovery.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bad Build
Next
From: Bruce Momjian
Date:
Subject: Re: Bad Build