The logical backup tooling encrypts the database dump and credentials, then signs a manifest over the encrypted artifacts. Restore checks the signature, set identity, inventory and digests before decryption or database restore.
What makes a recovery set usable
- Encryption
- age-encrypted artifacts; the decryption identity stays with the operator.
- Manifest
- Bind set ID, source bucket, capture time, file sizes and SHA-256 digests.
- Signature
- Verify against the retained signer history at the capture timestamp.
- Retention
- Storage-side locks and lifecycle rules protect retained objects.
The capture host must not be able to erase recovery history
The backup design removes host-side pruning. Storage allows write/read but refuses deletion or overwrite of retained objects. A plaintext marker cannot select an automatic restore point.
Key rotation, incomplete uploads and activation status
Rotation preserves old signing-key validity windows. Replacing trust history with only the newest key would orphan old backups. An incomplete upload without its manifest and signature is not restored.
The runbook separates the initial whole-server backup from activation of logical backups and the first restore drill. A daily cadence implies a recovery point of at most 24 hours; point-in-time recovery is deferred.
These are repository-defined recovery mechanisms and prerequisites. This portfolio does not claim a newly executed production restore or a measured recovery time.