Cannot grant "supabase_admin" to postgres role as Owner in Supabase Dashboard
I am trying to sync my production project with my development project.
I generated the schema from prod then unlinked using the CLI.
Then, using the CLI, I linked to the development project and attempted to run
This gave the following output:
After receiving this error, I attempted the following command in the Supabase Dashboard:
After which, I received the next error:
My Supabase account within both projects is "Owner."
What should I do to properly execute my plan to sync the databases?
I generated the schema from prod then unlinked using the CLI.
Then, using the CLI, I linked to the development project and attempted to run
supabase db pushThis gave the following output:
After receiving this error, I attempted the following command in the Supabase Dashboard:
GRANT supabase_admin to postgres;After which, I received the next error:
ERROR: 42501: "supabase_admin" role memberships are reserved, only superusers can grant themMy Supabase account within both projects is "Owner."
What should I do to properly execute my plan to sync the databases?
