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:
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:
- How to fully back up a Supabase database, including all schemas (auth, public, storage, etc.) and data?
- How to ensure the storage buckets and objects are preserved so that the supabase‑storage container can list and serve the files correctly?
Thanks in advance!
