SupabaseS
Supabase6mo ago
Razil

Migrating project region with CLI issues.

Hello, I was following the documentation at https://supabase.com/docs/guides/platform/migrating-within-supabase/backup-restore but the step at Restore your Project with the CLI will fail with

ALTER DEFAULT PRIVILEGES
ALTER DEFAULT PRIVILEGES
ALTER DEFAULT PRIVILEGES
RESET
ERROR:  permission denied to set parameter "session_replication_role"


On github dicussion there is a mention which seems to be the issue:

If the postgres is not a superuser anymore, we would need a way to run supabase migrations with a superuser when required.

Is there any current solution for this? Thank you!
Was this page helpful?