Search Postgresql Archives

Re: How to restore database to previous state

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, May 10, 2020 at 2:43 PM Andrus <kobruleht2@xxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux