Supabase CLI - Provide option to restore a Postgres backup about cli

[dthyresson]

Sorry, I just realized perhaps this issues is better listed in the cli repo. If so, let me know and I will move it.

But, one hiccup I did think of when restoring a db is if existing user credentials would be signed with a different GOTRUE_JWT_SECRET ... and if then one's local dev environment would have to use that value and thus potentially expose the secret to others without good reason.

[kiwicopple]

transferring!

[sweatybridge]

CLI v1 offers way to mirror your staging/production database locally. You can run the following commands to dump schemas locally after linking to a hosted project.

supabase link --project-ref <your_project>
supabase db remote commit

There are a few flags that we pass to pg_dump to ensure that restoring works. If you are using a manual dump, possibly from another postgres provider, you need to verify locally that the dump works by creating a new migration.

supabase migration new manual_dump < dump.sql
supabase db reset

If reset succeeds without error, you may push the schema to a new supabase project with supabase db push.

To restore seed data to local database, you can create a file under supabase/seed.sql containing insert statements. With #160, we hope to expose a way to push seed data to your hosted supabase projects as well.