After applying the patch `revoke superuser access`, local development is broken
I just applied the patch as suggested in my notifications, then I thought I should "sync" my production with my local development running the command
supabase db remote commit
supabase db remote commit
.
It generate a new migration, and when I try to run it
supabase db reset
supabase db reset
I receive this error
Error: ERROR: role "postgres_temporary_object_holder" does not exist (SQLSTATE 42704)
Error: ERROR: role "postgres_temporary_object_holder" does not exist (SQLSTATE 42704)
Then I stop supabase, and now I can't even start it, with
supabase start
supabase start
supabase startApplying migration 20221029194050_remote_commit.sql...Applying migration 20221107171735_remote_commit.sql...Error: ERROR: role "postgres_temporary_object_holder" does not exist (SQLSTATE 42704)At statement 0: -- This script was generated by the Schema Diff utility in pgAdmin 4-- For the circular dependencies, the order in which Schema Diff writes the objects is not very sophisticated-- and may require manual changes to the script to ensure changes are applied in the correct order.-- Please report an issue for any failure with the reproduction steps.ALTER FUNCTION public.handle_new_user() OWNER TO postgres_temporary_object_holder;
supabase startApplying migration 20221029194050_remote_commit.sql...Applying migration 20221107171735_remote_commit.sql...Error: ERROR: role "postgres_temporary_object_holder" does not exist (SQLSTATE 42704)At statement 0: -- This script was generated by the Schema Diff utility in pgAdmin 4-- For the circular dependencies, the order in which Schema Diff writes the objects is not very sophisticated-- and may require manual changes to the script to ensure changes are applied in the correct order.-- Please report an issue for any failure with the reproduction steps.ALTER FUNCTION public.handle_new_user() OWNER TO postgres_temporary_object_holder;
Did I did something wrong? I could not understand the steps of applying this migration.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.