Re: Point in time recovery 20020822_01_pitr.patch - Mailing list pgsql-patches

From J. R. Nield
Subject Re: Point in time recovery 20020822_01_pitr.patch
Date
Msg-id 1030080432.2625.148.camel@localhost.localdomain
Whole thread Raw
In response to Re: Point in time recovery 20020822_01_pitr.patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Point in time recovery 20020822_01_pitr.patch
List pgsql-patches
On Fri, 2002-08-23 at 00:29, Tom Lane wrote:
> "J. R. Nield" <jrnield@usol.com> writes:
> >     * CREATE/DROP database are still unlogged. dbcommands.c needs a
> > re-write to make that possible, since all the file and directory
> > operations will need to be logged, as will the data.
>
> Why don't you log the operations symbolically, viz "create database foo
> with template bar"?  I can't see any reason to insist on a finer level
> of detail than that.

If you do symbolic logging like that, it forecloses any chance of adding
individual relation recovery, because the template might be ahead of the
log. That's main reason I avoided doing this with index builds. I don't
know if we will want that feature, but I didn't want to prevent us from
adding it.

>
>
> Just so you know: my feeling is this is already too late for 7.3.
>

I'm not in a position to answer this. I'll do whatever I can to address
concerns as they arise, and I'll continue to review my own work. Clearly
this is not a good area to find bugs "in the field".

>             regards, tom lane
>
--
J. R. Nield
jrnield@usol.com




pgsql-patches by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Point in time recovery 20020822_01_pitr.patch
Next
From: Tom Lane
Date:
Subject: Re: Point in time recovery 20020822_01_pitr.patch