I'm trying to run supabase locally but when i try to use auth i get the following error

running db migrations: Migrator: problem creating schema migrations: CREATE TABLE \"schema_migrations\" (\n\"version\" VARCHAR (14) NOT NULL\n);\nCREATE UNIQUE INDEX \"schema_migrations_version_idx\" ON \"schema_migrations\" (version);: ERROR: no schema has been selected to create in (SQLSTATE 3F000)

Does anyone have a clue to what I'm doing wrong?

Hello @Silver.! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Which method are you using to run supabase locally? the supabase cli or the docker-compose setup?

docker compose

Did you setup your

.env

file add a password for the

POSTGRES_PASSWORD

environment variable?

Yes

Do you have Docker Desktop?

No

Can you check if any of the containers were created?

Something like this?

Try running docker compose up again with the force recreate flag

docker-compose up -d --force-recreate

Got this

But did you get the initial error again?

Yes

Thread was archived by @Silver.. Anyone can send a message to unarchive it.