Daily backup download
🟢SQL
Hi Supabase,
We’re on a Pro plan and trying to figure out the current best way to get a production backup we can actually test against locally.
We used to have backup downloads that restored much more cleanly. Now we’ve tried:
- raw pg_dump
- supabase db dump
But restoring locally keeps running into managed schema/role issues (storage, auth, realtime, ownership/permissions, etc.), so it’s not behaving like the older backup-download flow.
What’s the recommended path now for a Pro project if we want to:
- get prod data?
- restore/test safely outside prod?
- ideally not rely on PITR unless that’s now the only real snapshot-style option?
Is the answer:
- enable PITR and use future restore points/backups
- restore into another Supabase project
- use supabase db dump
- something else?
If helpful I can share exact commands/errors.
Main one is this but in general I've had to chagne sql migrations to get past certain failures when the snapshot backup i used to download which i have from nov just works
We’re on a Pro plan and trying to figure out the current best way to get a production backup we can actually test against locally.
We used to have backup downloads that restored much more cleanly. Now we’ve tried:
- raw pg_dump
- supabase db dump
But restoring locally keeps running into managed schema/role issues (storage, auth, realtime, ownership/permissions, etc.), so it’s not behaving like the older backup-download flow.
What’s the recommended path now for a Pro project if we want to:
- get prod data?
- restore/test safely outside prod?
- ideally not rely on PITR unless that’s now the only real snapshot-style option?
Is the answer:
- enable PITR and use future restore points/backups
- restore into another Supabase project
- use supabase db dump
- something else?
If helpful I can share exact commands/errors.
Main one is this but in general I've had to chagne sql migrations to get past certain failures when the snapshot backup i used to download which i have from nov just works
