Local Migrations Don't Copy Database Roles

I'm trying to set up local Supabase for testing. I use a tool called PowerSync which requires its own

powersync_role

powersync_role

role. I'm trying to copy my schema from my linked cloud database to my local one, but the migration tries to apply rules set for the

powersync_role

powersync_role

without actually creating the role, so the migration fails. Am I doing something wrong? How do I fix this?

Local Migrations Don't Copy Database Roles - Supabase