Postgres Pro
Downloads
Home   >   mailing lists

Re: Step back to previous state (a.k.a. undo) - Mailing list pgsql-novice

From Jasen Betts
Subject Re: Step back to previous state (a.k.a. undo)
Date
Msg-id hncv4l$eg7$4@reversiblemaps.ath.cx
Whole thread Raw
In response to Step back to previous state (a.k.a. undo)  (A B <gentosaker@gmail.com>)
Responses Re: Step back to previous state (a.k.a. undo)  (damien clochard <damien@dalibo.info>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: A B
Date:
Subject: Step back to previous state (a.k.a. undo)
Next
From: damien clochard
Date:
Subject: Re: Step back to previous state (a.k.a. undo)