Menu

Which Supabase backups can you download?
📰

Which Supabase backups can you download?

DEV Community: postgres·AK D·about 2 hours ago
#MHNsLdtQ
#devtopostgresql#devto#dev#supabase#dump
Reading 0:00
15s threshold

Supabase takes a daily backup of every Pro, Team and Enterprise project. Pro keeps 7 days, Team 14 and Enterprise up to 30. Free projects get none, and the docs recommend exporting with supabase db dump yourself.

Whether you can download one of those backups depends on its type. Projects on Postgres 15.8.1.079 and newer get physical backups: you can restore the project from them in the dashboard, but there is no file to download. Supabase's knowledge base says the same for projects with PITR, where the downloadable backup.gz is no longer generated.

For most current projects, a copy you hold yourself means taking a logical dump:

supabase db dump --db-url "$DB_URL" -f roles.sql --role-only supabase db dump --db-url "$DB_URL" -f schema.sql supabase db dump --db-url "$DB_URL" -f data.sql --use-copy --data-only

Enter fullscreen mode

Exit fullscreen mode

$DB_URL is the connection string under Connect in the dashboard.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.