Creating and Managing Backups

Using Ghostwriter CLI to create and manage backups

Creating and Managing Backups

Ghostwriter CLI (>=v0.2.12) includes backup and restore commands to help you create and manage backups of your PostgreSQL database.

The backup command uses PostgreSQL's pg_dump to dump the contents of the database. The resulting SQL file is gunzipped and stored in the production_postgres_data_backups Docker volume. Each file is named with the current timestamp (e.g., backup_2023_05_23T15_54_19.sql.gz).

Use the --list flag to list all available backup files stored in the volume.

The restore command recreates the database using the specified backup file.