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

From Andrus
Subject How to restore database to previous state
Date
Msg-id 79BA655C25F1470CAABE070E5F412813@dell2
Whole thread Raw
Responses RE: How to restore database to previous state  ("Ahmed, Nawaz (Fuji Xerox Australia)" <Nawaz.Ahmed@aus.fujixerox.com>)
Re: How to restore database to previous state  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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 create standby server which replicates changes using 24 hour delay and data directory
backupsin 
 
every night.
However this requires separate delayed standby server .
Is there simpler solution, e.q reverse playback of wal segments starting from current data directory contents.

Andrus. 




pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: Best way to use trigger to email a report ?
Next
From: "Ahmed, Nawaz (Fuji Xerox Australia)"
Date:
Subject: RE: How to restore database to previous state