| From: | Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com> |
|---|---|
| To: | Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tablelog |
| Date: | 2009-02-10 16:36:38 |
| Message-ID: | 4991AD16.6070404@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>> While we are talking about this, is a development like Oracle "Flashback
>> queries" planned maybe?
>>
>
> You can "flashback" to old data, but you need to use the tablelog
> functions.
>
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?
More infos on oracle flashback nice feature:
http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
Bruno Lavoie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Vanasco | 2009-02-10 16:52:23 | does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump? |
| Previous Message | Ioana Danes | 2009-02-10 16:10:13 | Re: Query Question |