Today we’re adding Restore to a New Project.
You can use this new tool to copy data easily from an existing Supabase project to a new one. Restore to a New Project integrates seamlessly with daily physical backups and Point-in-Time Recovery (PITR) to provide flexible restoration options.
When physical backups are enabled, Supabase triggers daily backups of project data. You can use this backup to restore to a new Supabase project. The new project should match the original project attributes:
- Size of compute instance.
- Disk settings; volume type, size, IOPS, and throughput.
- SSL enforcement configuration.
- Network restrictions.
- Cloud region.
After launching your restored project, the rest of the process is automated. The length of time for a new project to provision will depend on the size of the source dataset.
The new project will be available in the Supabase Dashboard as soon as the copy process has completed. This project will behave as any other Supabase project and is completely independent of the source.
Point-in-Time Recovery#
In addition to daily backups it is possible to restore from a project with PITR enabled. This allows for very fine granularity when selecting the desired point to restore from. The process is very similar as with daily backup with the exception of being asked to select a specific time.
To ensure maximum flexibility a source project can be copied as many times as required, making the tool perfect for testing, development environments etc. However, please note that cloning from an already cloned project is not currently supported (this is in the works).
The Restore to a New Project feature can be found on the Supabase dashboard under database backups.