LAB CASE STUDY / RECOVER

Backup created.
Restore verified.

Custom-format backup, checksum, and a restore into a test database without changing the main data.

← All case studies
Lab demo · synthetic dataNODIVEXA local environment
3 tablesCounts and hashes match
4,740 bytesDemo archive size
6.03 secondsRestore in this lab

What we tested

Prove that the backup can be restored and the table contents match the source without overwriting the main database.

What we did

  1. Create a custom-format pg_dump with exit-code checks and atomic final file publishing.
  2. Record SHA256 and fingerprints for three tables.
  3. Restore into a separate test database and compare row counts and content hashes.

Test results

A 4,740-byte archive restored in approximately 6.03 seconds on this small dataset. Three tables matched the manifest. The main database fingerprint remained unchanged. Data also survived container recreation without deleting volumes.

Demo limitations

Results apply only to this small synthetic dataset. Backups are not encrypted or offsite. The test target shares the PostgreSQL instance. This is not a customer RPO/RTO promise.

LET’S BUILD SOMETHING RELIABLE

Your next step.
A conversation.

Tell us what you are running, what is getting in the way, and what you need next. Start directly on WhatsApp or Telegram.