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 20020307092200J.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
> 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 by date:

Previous
From: Greg Copeland
Date:
Subject: Re: Bad Build
Next
From: Eric Scroger
Date:
Subject: [Fwd: Re: [JDBC] A result was returned by the statement, when none was expected]