Backup

Take full and incremental backups.

Backup

A backup copies data to a safe place. A full backup copies everything; an incremental backup copies only changes since the last backup.

COPY orders TO '/tmp/orders.csv';
-- full: tüm tablo
-- incremental: son yedekten sonraki satırlar

Full takes all, incremental takes changes.

Backup — details

Incremental saves space but the restore needs a chain: first the full, then each incremental in order. A weekly full with daily incrementals is a common schedule.

Exercise Backup

Back up the orders table to /tmp/orders.csv: COPY orders TO '/tmp/orders.csv'.

Show example solution

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

Test yourself

What does a full backup copy?
- Everything
- Only the changes
- Only the views
- Only the indexes
Show answer

Everything — A full backup copies everything.

Export

COPY orders TO '____';

Show answer

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

Backup: match the terms

full

full
incremental

incremental
COPY TO

export
schedule

schedule

Next lesson: Recovery

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies