On Sun, May 10, 2020 at 2:43 PM Andrus 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 th
Hi,
Have you looked at the recovery parameter as below ?
recovery_target_time
Using this, you could achieve a PITR of the current database. If the recovery
requires WAL that does not exist on disk then you may have to restore it from
previous night's backup.
Please have a look at the docs for
