SupabaseS
Supabase•2mo ago
IPJT

Issue: Restoring logical backup from production to local fails

Hi!
I'm trying to restore a logical backup from my production Supabase database to my local development environment.

Command:
pnpm supabase db start --from-backup db_cluster-17-11-2025@02-24-02.backup --debug

Setup:
  • Supabase CLI: 2.20.5
  • Backup: Logical backup downloaded from Supabase Dashboard (production)
Logs from pnpm supabase db start --from-backup db_cluster-17-11-2025@02-24-02.backup --debug:

...
...
...
2025/11/19 14:05:17 Recv First Byte
+ ulimit -n
+ '[' '!' -z '' ']'
+ export ERL_CRASH_DUMP=/tmp/erl_crash.dump
+ ERL_CRASH_DUMP=/tmp/erl_crash.dump
+ '[' false = true ']'
+ echo 'Running migrations'
+ sudo -E -u nobody /app/bin/migrate
** (Postgrex.Error) ERROR 3F000 (invalid_schema_name) no schema has been selected to create in
    (ecto_sql 3.11.3) lib/ecto/adapters/sql.ex:1054: Ecto.Adapters.SQL.raise_sql_call_error/1
    (elixir 1.17.3) lib/enum.ex:1703: Enum."-map/2-lists^map/1-1-"/2
    (ecto_sql 3.11.3) lib/ecto/adapters/sql.ex:1161: Ecto.Adapters.SQL.execute_ddl/4
    (ecto_sql 3.11.3) lib/ecto/migrator.ex:755: Ecto.Migrator.verbose_schema_migration/3
    (ecto_sql 3.11.3) lib/ecto/migrator.ex:563: Ecto.Migrator.lock_for_migrations/4
    (ecto_sql 3.11.3) lib/ecto/migrator.ex:432: Ecto.Migrator.run/4
    (ecto_sql 3.11.3) lib/ecto/migrator.ex:170: Ecto.Migrator.with_repo/3
    nofile:1: (file)
2025/11/19 14:05:17 Sent Header: Host [api.moby.localhost]
2025/11/19 14:05:17 Sent Header: User-Agent [Docker-Client/unknown-version (darwin)]
2025/11/19 14:05:17 Send Done
2025/11/19 14:05:17 Recv First Byte
Stopping containers...
Pruned containers: [dd90c64c631563187bb89651eabbde7c532d4b445bde2533633ce067b187072b]
Pruned volumes: [supabase_db_supabase-test supabase_config_supabase-test]
Pruned network: [supabase_network_supabase-test]


Any help would be appreciated! 🙏
Was this page helpful?