Migrating to self host
self-hostedstorageauthAfter I pg dump and restore, supabase auth and supabase storage containers stop working. these are the errors.
supabase auth:
{"level":"fatal","msg":"running db migrations: Migrator: problem creating schema migrations: could not execute CREATE TABLE "schema_migrations" (\n"version" VARCHAR (14) NOT NULL,\nPRIMARY KEY("version")\n);\nCREATE UNIQUE INDEX "schema_migrations_version_idx" ON "schema_migrations" (version);: ERROR: no schema has been selected to create in (SQLSTATE 3F000)","time":"2025-12-22T18:08:41Z"}
supabase storage:
{"level":50,"time":"2025-12-22T18:04:06.946Z","pid":1,"hostname":"1fd419410044","region":"local","type":"startupError","error":{"raw":"{"cause":{"length":109,"name":"error","severity":"ERROR","code":"42P01","position":"15","file":"parse_relation.c","line":"1392","routine":"parserOpenTable"}}","name":"Error","message":"Migration failed. Reason: relation "migrations" does not exist","stack":"Error: Migration failed. Reason: relation "migrations" does not exist\n at /app/dist/internal/database/migrations/migrate.js:283:21\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async /app/dist/internal/database/migrations/migrate.js:340:22\n at async connectAndMigrate (/app/dist/internal/database/migrations/migrate.js:218:5)\n at async runMigrationsOnTenant (/app/dist/internal/database/migrations/migrate.js:184:3)\n at async main (/app/dist/start/server.js:56:5)"},"msg":"Server not started with error"}
supabase auth:
{"level":"fatal","msg":"running db migrations: Migrator: problem creating schema migrations: could not execute CREATE TABLE "schema_migrations" (\n"version" VARCHAR (14) NOT NULL,\nPRIMARY KEY("version")\n);\nCREATE UNIQUE INDEX "schema_migrations_version_idx" ON "schema_migrations" (version);: ERROR: no schema has been selected to create in (SQLSTATE 3F000)","time":"2025-12-22T18:08:41Z"}
supabase storage:
{"level":50,"time":"2025-12-22T18:04:06.946Z","pid":1,"hostname":"1fd419410044","region":"local","type":"startupError","error":{"raw":"{"cause":{"length":109,"name":"error","severity":"ERROR","code":"42P01","position":"15","file":"parse_relation.c","line":"1392","routine":"parserOpenTable"}}","name":"Error","message":"Migration failed. Reason: relation "migrations" does not exist","stack":"Error: Migration failed. Reason: relation "migrations" does not exist\n at /app/dist/internal/database/migrations/migrate.js:283:21\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async /app/dist/internal/database/migrations/migrate.js:340:22\n at async connectAndMigrate (/app/dist/internal/database/migrations/migrate.js:218:5)\n at async runMigrationsOnTenant (/app/dist/internal/database/migrations/migrate.js:184:3)\n at async main (/app/dist/start/server.js:56:5)"},"msg":"Server not started with error"}
