Re: How to restore database to previous state - Mailing list pgsql-general

From David G. Johnston
Subject Re: How to restore database to previous state
Date
Msg-id CAKFQuwYUUJi=vKTPW+Zz4dJB6Ck0mP-kixoGK_j2iyMNtwkoyQ@mail.gmail.com
Whole thread Raw
In response to How to restore database to previous state  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
On Sun, May 10, 2020 at 2:43 PM Andrus <kobruleht2@hot.ee> wrote:
Is there simpler solution, e.q reverse playback of wal segments starting from current data directory contents.

There is no "unwind" or "undo" capability in PostgreSQL.  You need to separately get the database state to a point sometime before the target time and then restore until you attain the target time.

David J.

pgsql-general by date:

Previous
From: "Ahmed, Nawaz (Fuji Xerox Australia)"
Date:
Subject: RE: How to restore database to previous state
Next
From: Dennis Ryan
Date:
Subject: Hash partitioning, what function is used to compute the hash?