Skip to main content

Questions tagged [point-in-time-recovery]

Point-in-time-recovery (PITR) is the ability to recover a database to the state it had at any given point in time. In relational databases, this is done by replaying the transaction log from a checkpoint that marks the beginning of a base backup.

Filter by
Sorted by
Tagged with
0 votes
1 answer
30 views

Point-in-Time-Recovery of Postgres at an arbitrary time for audit purposes [closed]

TL;DR Would you recommend using CDC or pg_wal-based recovery to reproduce the state of the database in an arbitrary time, or stick with joining SCD2 tables (with start end end date for every record) ...
Mr Arkadin's user avatar
0 votes
1 answer
116 views

How to make sure that all required wal files are availables before starting a standby server?

Im writing a script to restore a postgres standby server that was out of sync with the master node for a while. I would like the following behavior Check if i can go with pg_rewind If pg_rewind fails,...
meilleureVie's user avatar
0 votes
0 answers
82 views

Restore issue with Pgbackrest

I am using Pgbackrest to backup and restore postgresql databases. Backup is okay, but when I want to restore database to point in time or last backup, although database files are located in data ...
Farid Zahidov's user avatar
2 votes
2 answers
640 views

Why is PostgreSQL data checksums not enabled by default?

According to user comments PostgreSQL data checksums have very minimal runtime overhead (both CPU and storage) but would allow (among other things) using pg_rewind for point in time recovery (PITR). ...
Mikko Rantalainen's user avatar
2 votes
1 answer
116 views

PostgreSQL WAL for PITR recover

I don't think my question makes any sense with the answer, but simply to confirm my doubt? I understand that PITR recovery is done with logs from the same database release (this is what I learned in ...
SAM's user avatar
  • 23