Skip site navigation (1) Skip section navigation (2)

Re: Step back to previous state (a.k.a. undo)

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Step back to previous state (a.k.a. undo)
Date: 2010-03-12 08:48:21
Message-ID: hncv4l$eg7$4@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-novice
On 2010-03-11, A B <gentosaker(at)gmail(dot)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


In response to

Responses

pgsql-novice by date

Next:From: damien clochardDate: 2010-03-12 11:17:58
Subject: Re: Step back to previous state (a.k.a. undo)
Previous:From: Carel CombrinkDate: 2010-03-12 08:09:45
Subject: PostgreSQL questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group