SupabaseS
Supabase•4y ago
drocha

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.

It generate a new migration, and when I try to run it supabase db reset I receive this error

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
Applying 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.
Was this page helpful?