I’m trying to use postgresql instead of sqlite in my app development. I used remix boilerplate template to develop my app. after installing postgresql in my local (using HomeBrew), I created database, created a user and grant all permissions to the user for the db. when I ran command " npx prisma migrate dev --name init", it throwed an error, saying:
Error: P3014
Prisma Migrate could not create the shadow database. Please make sure the database user has permission to create databases. Read more about the shadow database (and workarounds) at https://pris.ly/d/migrate-shadow
Original error:
ERROR: permission denied to create database
0: schema_core::state::DevDiagnostic
at schema-engine/core/src/state.rs:276.
please help me in solving this error. and also welcome to all the suggestions that can be done to sort out this error.