BrixFax Px4

Tableau de Bord

Supa DB BU

Local Supabase PostgreSQL database backup procedure. This backs up the database only. It does not back up Supabase Storage files such as uploaded images.

What this backup creates

  • roles.sql
  • schema.sql
  • data.sql
  • backup_manifest.txt
  • sha256.txt

Step 1: Start Docker Desktop

Start Docker Desktop first and wait until it is fully running. The Supabase CLI uses Docker indirectly for the database dump tools.

Optional quick check in PowerShell:

docker info --format "Docker server: {{.ServerVersion}}"

Step 2: Copy the Supabase DB URI

  1. Open the Supabase Dashboard.
  2. Open the BrixFax project.
  3. Go to Connect.
  4. Select the Direct tab.
  5. Choose Session pooler.
  6. Choose URI.
  7. Copy the full PostgreSQL URI from the connection string box.
  8. Replace [YOUR-PASSWORD] with the real database password.

Do this only locally. Do not paste the full URI or database password into this web app, into source files, or into ChatGPT.

Step 3: Run the local backup script

Open normal PowerShell in the folder where the backup script is stored.

.\RUN_SUPABASE_DB_BACKUP.ps1

When PowerShell asks for the Supabase DB connection string, paste the full PostgreSQL URI.

Step 4: Check the output

Each run should create a timestamped backup folder, for example:

supabase_backup_YYYY_MM_DD_HH-mm

Confirm that the expected SQL files, manifest file, and checksum file were created.

Step 5: Replicate backups to G: and H:

After this, use SyncBackFree to replicate the backups to disks G: and H:.

Important safety rules

  • This page does not run the backup.
  • This page does not store the DB URI.
  • This page does not store the database password.
  • Run the backup script locally from PowerShell.
  • Storage images/files need a separate backup procedure.