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

and

schema

schema

(

data

data

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

.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

But is doing the same thing for table in

schema.sql

schema.sql

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

Thx for helping !

Supabase•14mo ago•

1 reply

loup

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

and

schema

schema

(

data

data

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

.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

But is doing the same thing for table in

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

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

Similar Threads

Similar Threads

Similar Threads