Production Best Practices

Backup and Recovery

0:00

0% complete

LearnStep 1 of 2

Backup Strategies

Learning Objectives

•Create backups
•Restore databases
•Automate backup processes

Lesson Outline

LearnStep 1/2

Backup Strategies

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

pg_dump (Logical Backup)

bash

Python Backup Script

python

Restore

bash

Automated Backup with Cron

bash