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.sqlschema.sqldata.sqlbackup_manifest.txtsha256.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
- Open the Supabase Dashboard.
- Open the BrixFax project.
- Go to Connect.
- Select the Direct tab.
- Choose Session pooler.
- Choose URI.
- Copy the full PostgreSQL URI from the connection string box.
- 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.