Re: Patch for disaster recovery - Mailing list pgsql-patches

From Michael Fuhr
Subject Re: Patch for disaster recovery
Date
Msg-id 20050220083525.GA15307@winnie.fuhr.org
Whole thread Raw
In response to Re: Patch for disaster recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch for disaster recovery
Next
From: Bruce Momjian
Date:
Subject: Re: Patch for disaster recovery