S
Supabase•3mo 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"
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!
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?