| From: | George(dot)T(dot)Essig(at)stls(dot)frb(dot)org | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org | 
| Subject: | Re: Table Timemachine! | 
| Date: | 2002-12-18 19:16:58 | 
| Message-ID: | 20021218192552.E20DA476D2F@postgresql.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
There is a presentation about journaling databases available at:
http://conferences.oreillynet.com/cs/os2002/view/e_sess/2551
The basic idea is that with database journaling you can extract 
a snapshot of the data at any past date.  At the time of the talk, 
the speaker said he was going to make the code public.  I don't know 
if this was ever done.
George Essig
> I've been asked by a colleague about methods to keep track of
> 'previous' contents of a table - i.e. changes made and a way of
>  getting back to a previous state. 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2002-12-18 19:23:55 | Re: ORDER BY random() LIMIT 1 slowness | 
| Previous Message | Jean-Luc Lachance | 2002-12-18 19:09:42 | Re: ORDER BY random() LIMIT 1 slowness |