Error syncing auth and storage schemas from remote to local
I need to synchronize the local database with the remote one. I have executed the following commands:
supabase db pull
supabase db push --local
Ok. The operation was successful.
After I executed:
supabase db pull --schema storage
supabase db push --local
ERROR: permission denied for schema storage (SQLSTATE 42501)
At statement: 0
create type "storage"."buckettype" as enum ('STANDARD', 'ANALYTICS')
How should I proceed?
The need arises from the fact that I have a “data-only” dump that errors when I try to push it locally because it tells me:
psql:supabase/dumps/dump1.sql:530: ERROR: column "type" of relation "buckets" does not exist
LINE 1: ...le_size_limit", "allowed_mime_types", "owner_id", "type") VA...
^
psql:supabase/dumps/dump1.sql:570: ERROR: column "level" of relation "objects" does not exist
LINE 1: ...etadata", "version", "owner_id", "user_metadata", "level") V...
^
psql:supabase/dumps/dump1.sql:589: ERROR: relation "storage.prefixes" does not exist
LINE 1: INSERT INTO "storage"."prefixes" ("bucket_id", "name", "crea...
Can anyone help me?0 Replies