Re: How to restore database to previous state

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to restore database to previous state
Date: 2020-05-11 00:25:41
Message-ID: CAKFQuwYUUJi=vKTPW+Zz4dJB6Ck0mP-kixoGK_j2iyMNtwkoyQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, May 10, 2020 at 2:43 PM Andrus <kobruleht2(at)hot(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Ryan 2020-05-11 04:33:22 Hash partitioning, what function is used to compute the hash?
Previous Message Ahmed, Nawaz (Fuji Xerox Australia) 2020-05-10 23:29:50 RE: How to restore database to previous state