ReviveDB: Supabase backups restore-tested against the source schema

From: ReviveDB via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: ReviveDB: Supabase backups restore-tested against the source schema
Date: 2026-10-28 11:28:20
Message-ID: 179318690026.1249.3761797662889179732@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

ReviveDB backs up Supabase projects on Postgres 17 outside Supabase, and restores every database backup into a temporary PostgreSQL database before it counts as verified.

The restore is compared with an inventory of the source: tables, rows, columns, constraints, indexes, sequences, views, functions, triggers, RLS policies, grants and extensions. Row counts alone miss a restore that loses a constraint or a policy.

Each backup run uses its own short-lived, read-only Postgres role that also reads rows behind row-level security. The same recovery point holds Auth data, Storage files and Edge Functions.

A recovery point restores into a new Supabase project, or into the original after a rehearsal on a copy. Free for one project: [https://revivedb.dev](https://revivedb.dev)

Browse pgsql-announce by date

  From Date Subject
Next Message Dalibo via PostgreSQL Announce 2026-10-28 12:17:47 PostgreSQL Anonymizer 3.3 : Major Security Update
Previous Message Estuary via PostgreSQL Announce 2026-10-28 11:27:31 Estuary Expands PostgreSQL CDC with Targeted Backfills and Scalable Discovery