How completely migrate from one supabase project to another (self hosted)

Okay I try but without success to completely move my supabase instance to another server. For now Ive just try to migrate

roles

roles

roles

roles and

schema

schema

schema

schema (

data

data

data

data is gonna be after that). So I have my 2 files

.sql

.sql

.sql

.sql but when I try to push them in the new database I have all kind of error saying for example :

psql \                                                                    ─╯
  --single-transaction \
  --variable ON_ERROR_STOP=1 \
  --file roles.sql \
  --dbname "postgres://admin:password@myhost:port/db"

SET
SET
SET
psql:roles.sql:7: ERROR:  role "supabase_realtime_admin" already exists

psql \                                                                    ─╯
  --single-transaction \
  --variable ON_ERROR_STOP=1 \
  --file roles.sql \
  --dbname "postgres://admin:password@myhost:port/db"

SET
SET
SET
psql:roles.sql:7: ERROR:  role "supabase_realtime_admin" already exists

psql \                                                                    ─╯
  --single-transaction \
  --variable ON_ERROR_STOP=1 \
  --file roles.sql \
  --dbname "postgres://admin:password@myhost:port/db"

SET
SET
SET
psql:roles.sql:7: ERROR:  role "supabase_realtime_admin" already exists

psql \                                                                    ─╯
  --single-transaction \
  --variable ON_ERROR_STOP=1 \
  --file roles.sql \
  --dbname "postgres://admin:password@myhost:port/db"

SET
SET
SET
psql:roles.sql:7: ERROR:  role "supabase_realtime_admin" already exists

But is doing the same thing for table in

schema.sql

schema.sql

schema.sql

schema.sql that doesnt exist in the new one so Im completely lost...

Thx for helping !

How completely migrate from one supabase project to another (self hosted)

Similar Threads

Similar Threads

Similar Threads