| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Andreas 'ads' Scherbaum" <adsmail(at)wars-nicht(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tablelog |
| Date: | 2009-02-10 20:31:20 |
| Message-ID: | 23872.1234297880@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Andreas 'ads' Scherbaum" <adsmail(at)wars-nicht(dot)de> writes:
> On Tue, 10 Feb 2009 11:36:38 -0500 Bruno Lavoie wrote:
>> Oracle Flashback Query seems to use undo logs to return in a point in
>> time if the undo retention param permit it. You can do it with a date,
>> or with the SCN (system change number), a kind of transaction number. It
>> saves you administration task and table management, and *space*.
>>
>> Is this doable with PG, using some pg transaction logs?
> I think, the only way is to use PITR and roll the backup forward during
> the exact point you want to see.
contrib/spi/timetravel might be worth looking at too. It hasn't been
touched in awhile but AFAIK it still works.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Hughes | 2009-02-10 21:15:22 | Referencing Cursor/Row/Record Fields in PL/PgSQL |
| Previous Message | Andreas 'ads' Scherbaum | 2009-02-10 20:26:59 | Re: tablelog |