postgres-backup

What problem does it solve?

Protects Metabase PostgreSQL data by providing consistent backup and restore procedures, reducing the risk of data loss from container failures, accidental deletions, or configuration mistakes. It standardizes dump formats, verification steps, and offsite storage so teams can recover quickly and confidently.

Core Features & Use Cases

• Full database dumps: Create consistent, compressed dumps of the entire metabase database using pg_dump inside the metabase-db container.
• Table-specific exports: Export individual tables such as report_dashboard for targeted snapshots or migrations.
• Restore workflows: Restore dumps to the same or different databases and run non-destructive test restores to validate integrity.
• Scheduled and offsite backups: Integrate with Borg for versioned, passphrase-protected remote backups and automated retention.
• Verification and troubleshooting: Verify dump integrity, list dump contents, and provide common checks for connection and permissions issues.

Quick Start

Create a compressed pg_dump of the metabase database inside the metabase-db container, copy it to /var/backups on the host, and verify it can be restored to a test database.