Skip to main content

Review the Nightly Backup Reference

This path inspects repository artifacts. It does not query PostgreSQL, write objects, schedule a job, or test recovery.

Prerequisites​

  • A checkout of this repository
  • A shell with sed and rg
  • No database or cloud credentials

Run the inspection​

From the repository root:

test -f examples/enterprise-migration/nightly-backup/nightly-backup.yaml
sed -n '1,100p' examples/enterprise-migration/nightly-backup/nightly-backup.yaml
rg -n 'sql_select|_backup_metadata|_checksum|gcp_cloud_storage' \
  examples/enterprise-migration/nightly-backup/nightly-backup.yaml

Expected output​

The file check exits successfully. The final command identifies the database inputs, recovery-context fields, checksum mapping, and cloud-storage output.

Cleanup​

No files or external resources are created.

Common failures​

  • A missing file means the checkout does not contain the referenced artifact.
  • No rg matches means the configuration structure changed; inspect the complete file and update this route.
  • A readable configuration does not establish snapshot consistency, object delivery, or recovery behavior.

Next: Inspect table extraction.