Skip to content

Database Copy

Copying a database between clusters looks like a single operation. Under it, Muppy chains:

  1. Backup one or more databases on the source cluster.
  2. Upload the pg_dumps from the source Host to an S3 bucket.
  3. Download them onto the Host running the target cluster.
  4. Restore them there.
  5. Delete the temporary files.

Starting a copy

Three entry points:

  • the Actions (⚙) menu of the database list (Muppy / Databases / Databases), once at least one database is selected
  • the Databases tab of a Database Cluster, via Copy Databases
  • a database form, via Copy

All three open the Copy Databases (using pg_dump) wizard:

  1. Pick the S3 bucket that will hold the pg_dumps.
  2. Adjust the list of databases to copy.
  3. Optionally pick a pg_restore Callback Task, applied to every database in the list.
  4. Click Launch.

The copy runs in the background as a Task. Follow it under Muppy / Qs.

The Copy Databases wizard

The available options are a mix of the backup and restore options.