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

franckpachot profile image

Aurora Limitless - Global Consistency (ACID)

Franck Pachot -

franckpachot profile image

Aurora Limitless - Reference Tables

Franck Pachot -

ymc9 profile image

Building Multi-Tenant Apps Using Clerk's "Organization" and Next.js

ymc9 -

edvichuki profile image

Working with PostgreSQL Date and Time Functions

Gichuki Edwin -