| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Patch for disaster recovery |
| Date: | 2005-02-20 08:35:25 |
| Message-ID: | 20050220083525.GA15307@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-02-20 14:43:11 | Re: Patch for disaster recovery |
| Previous Message | Tom Lane | 2005-02-20 07:21:00 | Re: Patch for disaster recovery |