Local Backup Download
Hello,
I'm trying to download a backup of all my database data! I would like a local copy of my data as a fail safe especially since I don't update the data too often and I have a lot of data!
I have done lots of reading and no luck so far. I have been able to download a cop of the database structure but not the actual database content.
I have read this guide and that's how I was able to get the structure: https://supabase.com/docs/guides/platform/migrating-within-supabase/backup-restore
Backup and Restore using the CLI | Supabase Docs
Learn how to backup and restore projects using the Supabase CLI
2 Replies
Should pull the data.
https://supabase.com/docs/reference/cli/supabase-db-dump
You could also use PSQL an pg_dump to get everything.
Also searching found this user post https://waxlyrical.medium.com/backup-your-supabase-db-with-pg-dump-14f08c40e456 but there were others.