Recovery

Learn point-in-time recovery.

Recovery

Recovery restores damaged or deleted data from a backup. Point-in-time recovery (PITR) rolls data back to a specific moment; WAL logs make it possible.

COPY orders FROM '/tmp/orders.csv';
-- PITR: WAL logları belirli ana kadar yürütülür

PITR restores to a specific moment.

Recovery — details

During restore the database is unavailable. In PITR a full backup is loaded first, then WAL records are replayed in order. The target time stops the WAL replay.

Exercise Recovery

Restore the orders table from /tmp/orders.csv: COPY orders FROM '/tmp/orders.csv'.

Show example solution

COPY orders FROM '/tmp/orders.csv';

Test yourself

Import

COPY orders FROM '____';

Show answer

COPY orders FROM '/tmp/orders.csv';

Recovery: match the terms

recovery

recovery
PITR

point-in-time
WAL

log
restore

restore
What does PITR provide?
- Less disk space
- Restoring to a specific point in time
- Faster writes
- Column compression
Show answer

Restoring to a specific point in time — PITR provides restore to a specific moment.

Next lesson: Summary - Security and backup

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies