How to Backup Supabase Database: Complete Tutorial
Master Supabase database backups with our comprehensive guide. Learn pg_dump, automated backups, and restore procedures using Database Vault.
Understanding Supabase Backups
Supabase is built on PostgreSQL, which means you can use standard PostgreSQL backup tools. However, Supabase also provides connection pooling and specific configurations that require careful handling. Database Vault simplifies this process.
How to Backup Supabase with Database Vault
Step 1: Get Your Supabase Connection String
Find your Supabase connection details:
- Go to your Supabase project dashboard
- Navigate to Settings → Database
- Find the "Connection string" section
- Copy the connection string (URI format)
Format: postgresql://postgres:[YOUR-PASSWORD]@db.[PROJECT-REF].supabase.co:5432/postgres
Step 2: Add Supabase to Database Vault
Add your Supabase database to Database Vault:
Important Security Note:
Use the connection pooler connection string for better performance, or the direct connection string for full pg_dump compatibility. Never share your database password publicly.
Step 3: Configure Backup Settings
Supabase databases benefit from regular backups. Configure your preferred schedule:
Supabase Backup Best Practices
Use Connection Pooler for Production
Supabase connection pooler handles connection limits better for automated backups.
Backup During Low-Traffic Periods
Schedule backups during off-peak hours to minimize impact on your application.
Include All Schemas
Ensure your backup includes all schemas, including public, auth, and storage schemas.