How to restore database to previous state

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: How to restore database to previous state
Date: 2020-05-10 21:43:05
Message-ID: 79BA655C25F1470CAABE070E5F412813@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 backups in
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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ahmed, Nawaz (Fuji Xerox Australia) 2020-05-10 23:29:50 RE: How to restore database to previous state
Previous Message Rory Campbell-Lange 2020-05-10 19:17:21 Re: Best way to use trigger to email a report ?