© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•13mo ago•
4 replies
Tanner Scadden

Looking to sync two supabase projects

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 banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Keeping two Supabase projects in Sync Prod|Dev
SupabaseSSupabase / help-and-questions
4y ago
Switching Between two different local Supabase Projects issue
SupabaseSSupabase / help-and-questions
14mo ago
Looking for sample Projects integrating Supabase Auth + NextJs
SupabaseSSupabase / help-and-questions
7mo ago
reverse sync Supabase back to Supabase cli project
SupabaseSSupabase / help-and-questions
2w ago