Database Backup, Restore and Copy

Muppy backs up and restores PostgreSQL databases as pg_dump archives, and copies databases between clusters.

Archives are stored in S3 buckets — AWS S3 or any compatible object store.

Backups and restores run interactively or on a schedule. Muppy also purges dumps past their retention period — see Backup Retention.

Callback Tasks let you customise the restore and copy process: run SQL against the database before restoring, anonymise it right after, and so on. See Restore Callbacks.

Every backup operation runs as a Muppy Task from the script muppy_postgresql_base.scripts.pg_dump, which you can reuse in your own Tasks.