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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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