© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•2y ago•
1 reply
Fainaru

pg_restore ERROR: permission denied

When using pg_restore it gives me this error pg_restore: error: could not execute query: ERROR: permission denied: "RI_ConstraintTrigger_a_30247" is a system trigger
Command was: ALTER TABLE public.areas ENABLE TRIGGER ALL;

I am using pg_restore --data-only --disable-triggers -d [link] seed.dump
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

Permission denied after pg_net upgrade
SupabaseSSupabase / help-and-questions
4y ago
Permission denied
SupabaseSSupabase / help-and-questions
3y ago
supabase start gives ERROR: permission denied to create extension "pg_net"
SupabaseSSupabase / help-and-questions
3y ago
Getting authenticator@postgres error permission denied
SupabaseSSupabase / help-and-questions
6mo ago