Docker Compose Postgres Backup: pg_dump, Cron and Restore Tests
Back up Postgres in Docker Compose with pg_dump via compose exec, schedule it with host cron, ship dumps off-host, and automate a restore test that proves it works.
13 min read
Tag
backup
PostgreSQL Backup and Restore: pg_dump, PITR and Restore Testing
Choose between pg_dump and base backups with WAL archiving based on RPO and RTO, run point in time recovery, and prove backups work with scheduled restores.
14 min read