Re: Point in time recovery 20020822_01_pitr.patch
От | Tom Lane |
---|---|
Тема | Re: Point in time recovery 20020822_01_pitr.patch |
Дата | |
Msg-id | 17453.1030081388@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Point in time recovery 20020822_01_pitr.patch ("J. R. Nield" <jrnield@usol.com>) |
Список | pgsql-patches |
"J. R. Nield" <jrnield@usol.com> writes: > On Fri, 2002-08-23 at 00:29, Tom Lane wrote: >> 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. We are already assuming that the template database is stable while it's being copied. While there are obvious risks in that assumption, I don't think that you need to eliminate the assumption as an essential component of PITR ... and I think that there are a number of issues that'd have to be solved that are completely unrelated to PITR (eg, how do you lock a table that's in a database you aren't in, and indeed that you don't even know exists, because you can't read the pg_class table that describes it?) My advice: this is a job not to tackle for version 1, and maybe not for version 2, 3, or 4... regards, tom lane
В списке pgsql-patches по дате отправления: