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

tigawanna profile image

supabase functions (not edge)

Dennis kinuthia -

gwenshap profile image

Debunking 6 common pgvector myths

Gwen (Chen) Shapira -

pfilaretov42 profile image

Spring Boot Avengers: Uniting Spring Data JDBC and PostgreSQL's JSONB

Petr Filaretov -

seewhy profile image

How to Consolidate Multiple PostgreSQL Databases into a Single Database Using Debezium, Kafka, and Power BI for Analytics

CYRIL OSSAI -