Error: P1003 : Prisma Migrate could not create the shadow database.

Error: P1003 : Prisma Migrate could not create the shadow database.


Fix your Prisma Migration error:



1. Update your .env config .

DATABASE_URL="postgresql://postgres:asdf4321@127.0.0.1:5432/postgres"
SHADOW_DATABASE_URL="postgresql://postgres:asdf4321@127.0.0.1:5432/postgres"
Enter fullscreen mode

Exit fullscreen mode



2. Update schema.prisma file.

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider          = "postgresql"
  url               = env("DATABASE_URL")
  shadowDatabaseUrl = env("SHADOW_DATABASE_URL")
}
Enter fullscreen mode

Exit fullscreen mode

Image description

That’s solved now.



3. Now migrate your Database.

 npx prisma migrate dev
Enter fullscreen mode

Exit fullscreen mode



Source link
lol

By stp2y

Leave a Reply

Your email address will not be published. Required fields are marked *

No widgets found. Go to Widget page and add the widget in Offcanvas Sidebar Widget Area.