© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3mo ago•
8 replies
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
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
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]
...
...
...
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! 🙏
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

Unable to connect to database after restoring backup
SupabaseSSupabase / help-and-questions
3mo ago
Local Backup Download
SupabaseSSupabase / help-and-questions
5mo ago
Production Project Stuck Restoring [Urgent]
SupabaseSSupabase / help-and-questions
3y ago
Restore backup to local postgresql database
SupabaseSSupabase / help-and-questions
3y ago