We are wanting to set up a new project as a "playground" environment for our clients to test out integrations and different features we have without effecting their production data. We were hoping that supabase had a way to resync data for a project based on a backup of another, but it looks like it's not possible.
I tried doing this using
pg_dump
pg_dump
, but ran into issues with permissions around triggers or other schemas. Granted, I am not very experienced in this.
I also tried using the supabase cli, but couldn't find a way to reset a project based on a dump file or backup.
Has anyone done this before? What would be the best way to handle this?
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.