Re: Point in time recovery: recreating relation files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: marc(at)bloodnok(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Point in time recovery: recreating relation files
Date: 2002-03-07 05:29:51
Message-ID: 8107.1015478991@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-03-07 05:53:26 Re: Bad Build
Previous Message Tom Lane 2002-03-07 05:19:27 Re: Bad Build