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.
9 questions
0
votes
0
answers
21
views
MariaDB PITR from mariadb-backup (GTID) fails "ERROR: Found out of orders GTID"
I'm trying to perform a Point-in-Time Recovery on a MariaDB 11.4.2 where GTID is enabled. I have successfully restored a full and an incremental backup using mariadb-backup, but I'm failing at the ...
- 163
0
votes
1
answer
36
views
mysqlbinlog not applying updates for PITR
I'm running Percona MySQL 8.0.42-33 on RHEL 9.6.
I have a problem when attempting point-in-time-recovery, where I can restore the database from the mysqldump backup, but the application of the binlog ...
3
votes
1
answer
212
views
Is using Transaction XID or LSN the more accurate and precise way to perform PITR?
I am practising Point in Time Recovery (PITR) on PostgreSQL 13 against accidental data deletion. Since PostgreSQL offers multiple parameters to perform PITR, I am bit confused choosing between ...
- 688
0
votes
0
answers
500
views
How to solve cp: cannot stat 00000002.history: No such file or directory/LOG: invalid primary checkpoint record during PITR?
I have tried to recover a database, using the Point-in-Time Recovery method, through the postgresql.conf file, setting the recovery_target_time parameter at a specific time in past, but I cannot start ...
0
votes
1
answer
83
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) ...
0
votes
1
answer
363
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,...
0
votes
1
answer
271
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 ...
4
votes
2
answers
2k
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). ...
- 1,109
2
votes
1
answer
147
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 ...
- 23