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
docs for other such recovery parameters:
https://www.postgresql.org/docs/12/runtime-config-wal.html
Regards,
Nawaz
-Original Message-
From: Andrus
Sent: Monday, 11 May 2020 7:43 AM
To: pgsql-general
Subject: How to restore database to previous state
Hi!
Postgres 12 database is runi
Hi!
Postgres 12 database is runing on Debian
max_wal_size = 5GB
is specified in postgres.conf file
How to restore database to some previous state, e.q. before important data was
accidently deleted.
Binary asynchrunous replication with slot is also used.
I looks like it is possible to creat
