PostgreSQL Backup and Recovery
Backup Types
| Type | Tool | Use Case |
|---|---|---|
| Logical | pg_dump | Single database, portable |
| Physical | pg_basebackup | Full cluster, point-in-time |
| Continuous | WAL archiving | Point-in-time recovery |
Learning Objectives
Lesson Outline
| Type | Tool | Use Case |
|---|---|---|
| Logical | pg_dump | Single database, portable |
| Physical | pg_basebackup | Full cluster, point-in-time |
| Continuous | WAL archiving | Point-in-time recovery |