How to restore database to previous state

Поиск
Список
Период
Сортировка
От Andrus
Тема How to restore database to previous state
Дата
Msg-id 79BA655C25F1470CAABE070E5F412813@dell2
обсуждение исходный текст
Ответы RE: How to restore database to previous state
Re: How to restore database to previous state
Список 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 по дате отправления:

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: Best way to use trigger to email a report ?
Следующее
От: "Ahmed, Nawaz (Fuji Xerox Australia)"
Дата:
Сообщение: RE: How to restore database to previous state