Grokbase › Groups › PostgreSQL › pgsql-novice › March 2010
FAQ
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?

Search Discussions

  • Jasen Betts at Mar 12, 2010 at 8:48 am ⇧

    On 2010-03-11, A B 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
  • Damien clochard at Mar 12, 2010 at 11:18 am ⇧

    Jasen Betts a écrit :
    On 2010-03-11, A B 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/

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMar 11, '10 at 6:54p
activeMar 12, '10 at 11:18a
posts3
users3
websitepostgresql.org
irc#postgresql

3 users in discussion

A B: 1 post Jasen Betts: 1 post Damien clochard: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase