Supabase-DB Backup and Restore
Hi Community,
I’m currently trying to back up my self‑hosted Supabase Postgres database. Right now, I’m using pg_dump and uploading the .dump file to S3. For restoration, I drop the database and restore it from the dump.
While the Postgres restore completes successfully, the supabase‑storage container fails to display files from my S3 bucket. I get errors indicating that the storage schema wasn’t backed up.
Can anyone advise:
1. How to fully back up a Supabase database, including all schemas (auth, public, storage, etc.) and data?
2. How to ensure the storage buckets and objects are preserved so that the supabase‑storage container can list and serve the files correctly?
Any guidance—or sample scripts—on achieving a complete backup and restore with everything working again would be greatly appreciated.
Thanks in advance!
I’m currently trying to back up my self‑hosted Supabase Postgres database. Right now, I’m using pg_dump and uploading the .dump file to S3. For restoration, I drop the database and restore it from the dump.
While the Postgres restore completes successfully, the supabase‑storage container fails to display files from my S3 bucket. I get errors indicating that the storage schema wasn’t backed up.
Can anyone advise:
1. How to fully back up a Supabase database, including all schemas (auth, public, storage, etc.) and data?
2. How to ensure the storage buckets and objects are preserved so that the supabase‑storage container can list and serve the files correctly?
Any guidance—or sample scripts—on achieving a complete backup and restore with everything working again would be greatly appreciated.
Thanks in advance!
