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

cezz profile image

If pg_dump is not a backup tool, what is?

Cezzaine Zaher -

franckpachot profile image

IN() Index Scan in PostgreSQL 17 and YugabyteDB LSM Tree

Franck Pachot -

firoj_mujawar profile image

SQL Performance: A Deep Dive into Indexing with examples

Firoj Mujawar -

megaminds profile image

Reasons to Migrate from ASP.NET MVC to .NET Core

Megaminds SEO -