ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseโ€ข4y agoโ€ข
4 replies
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
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 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;
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.
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

Superuser access to Supabase Vault
SupabaseSSupabase / help-and-questions
5mo ago
How do I use supabase_admin in local development? I need superuser in local dev.
SupabaseSSupabase / help-and-questions
3y ago
Local development: postgres docker image 15.8.1.094 is broken.
SupabaseSSupabase / help-and-questions
7mo ago
Local Development Issues
SupabaseSSupabase / help-and-questions
11mo ago