DEV Community

Cover image for Error: P1003 : Prisma Migrate could not create the shadow database.
Sarwar Hossain
Sarwar Hossain

Posted on

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

#prisma #postgres #p1003 #migrate

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

Image description

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

Top comments (0)

Read next

sam_shalemrajtara_8bda2 profile image

Full Stack Auth Implementation using Next js and Neon DB for Neon Challenge

Sam Shalem Raj Tara -

mdabidhussain profile image

OpenSourceSmith - Complete Kit to Forge Your Project

Md Abid Hussain -

jess profile image

Congrats to the Neon Open Source Starter Kit Challenge Winners!

Jess Lee -

thomascansino profile image

[DAY 99-101] I acquired a database certificate from freecodecamp

Thomas Cansino -