Question 169752 in PostgreSQL Question posted in
The official documentation can be found here.

Can’t init local env in Postgresql SUPABASE: why “schema ‘vault’ does not exist” error?

After using the hosted db, I’m trying to set up a local and staging env but seems not easy as I thought….

I’ve follow this guide https://supabase.com/docs/guides/cli/managing-environments#deploy-a-migration and after run supabase start I encouraged in this errorenter image description here
anyone can help me?

I’ve generate the migration supabase/migrations/_remote_commit.sql and pushed to github I’m not able to run supabae locally

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I probably found the solution

    I've added

    -- Name: vault; Type: SCHEMA; Owner: - CREATE SCHEMA IF NOT EXISTS vault;

    before

    -- -- Name: supabase_vault; Type: EXTENSION; Schema: -; Owner: -

    CREATE EXTENSION IF NOT EXISTS "supabase_vault" WITH SCHEMA "vault";


  2. 0

    Nothing, I had to comment the whole part regarding vault

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search