Jasen Betts a écrit :
> On 2010-03-11, A B <gentosaker@gmail.com> wrote:
>> Hello!
>>
>> Is it possible to tell a running postgres server to rememeber its
>> state at a certain timestamp, then let clients access the database,
>> do what ever they want, then just roll back to the timestamp?
>
> not using just SQL commands.
>
> AIUI there are two options
>
> 1 > PITR ("point in time recovery")
>
> 2 > dump and restore
>
>
3 > There's a brand new project on pgFoundry called e-maj that aims to
"undo" the SQL activity. It's not ready for production, though.
http://pgfoundry.org/projects/emaj/