Re: Patch for disaster recovery

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Patch for disaster recovery
Дата
Msg-id 20050220083525.GA15307@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: Patch for disaster recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Sun, Feb 20, 2005 at 02:21:00AM -0500, Tom Lane wrote:

> Just brainstorming here, but it seems to me that what might make some
> kind of sense is a command to "undelete all tuples in this table".

Would it be possible to start a transaction with specific snapshot
parameters?  Could you "time warp" that way, assuming that what
you're looking for hasn't already been vacuumed away?  Rather than
modifying anything, you'd SELECT or COPY the data somewhere and
then restore it when you came "back to the future."  Just another
brainstorm...certainly not thought very far through yet.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Patch for disaster recovery
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Patch for disaster recovery