Creating local project from remote -- ERROR relation graphql.schema_version does not exist
Hi guys!
I'm trying to create a local development environment from an existing remote project.
Following the guide at https://supabase.com/docs/guides/cli/local-development,
npx supabase init
npx supabase start
npx supabase db remote commit
npx supabase db reset
I get the following error running the reset command:
Looking at the generated migration file, it doesn't seem to create the table graphql.schema_version.
I'm guessing the CLI creates a different type of base database locally than what is hosted remotely? The remote project is 4-5 months old and been done entirely in production.
Do you guys know what I can do? Is there a better way to migrate the db, a way to ensure local is the same version as remote, or a safe way to upgrade the remote db?
My supabase CLI version is 1.12.2
Best regards
Donny
I'm trying to create a local development environment from an existing remote project.
Following the guide at https://supabase.com/docs/guides/cli/local-development,
npx supabase init
npx supabase start
npx supabase db remote commit
npx supabase db reset
I get the following error running the reset command:
Looking at the generated migration file, it doesn't seem to create the table graphql.schema_version.
I'm guessing the CLI creates a different type of base database locally than what is hosted remotely? The remote project is 4-5 months old and been done entirely in production.
Do you guys know what I can do? Is there a better way to migrate the db, a way to ensure local is the same version as remote, or a safe way to upgrade the remote db?
My supabase CLI version is 1.12.2
Best regards
Donny
