Following managing environments docs immediately results in failed migrations

Question

The docs in question https supabase com docs guides cli managing environments Running `supabase db remote commit` immediately generates a migration which cannot be applied EDIT to an instance started via the supabase cli and fails The offending line is `CREATE EXTENSION IF NOT EXISTS supabase vault WITH SCHEMA vault ` This fails in the type generation CI with `Error ERROR extension supabase vault is not available SQLSTATE 0A000 `

francis · Answer

Note I confirmed this behavior with a newly created project with no database changes made The migration generated from a new supabase project causes this error This is preventing any integration tests from running since they require a supabase instance to run against which cannot start due to this migration failure

francis · Answer

Found a related issue it appears that docs are out of date https github com supabase supabase issues 14056