A comprehensive guide to backing up PostgreSQL databases running in Docker, covering three approaches: local filesystem, AWS S3, and using Plakar (an open source deduplication backup tool). Includes shell scripts for automated daily backups via cron, restore procedures, and a cost comparison showing how Plakar's deduplication can reduce S3 storage from ~455 GB to ~65 GB after one year of growth. Also covers Plakar installation, repository setup, snapshot management, pruning policies, and syncing between local and S3 storage backends.
Table of contents
# How I Backed Up My Databases for 10+ Years# How Does Plakar Help?# Installing Plakar# Daily Database Backups with Plakar# Getting Ready with AWS and S3# Using S3 Storage with Plakar# Demo Video29.5K Impressions2 Comments