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

mrcaption49 profile image

Deploy a Django application on Render using PostgreSQL as the database and hosting images over AWS

Pranav Bakare -

tkssharma profile image

Dockerize nestjs application with Postgres

tkssharma -

murilogervasio profile image

How to make Multi-tenant applications with NestJS and Prisma 🚀.

Murilo Gervasio -

looph0le profile image

How to Set Up a PostgreSQL Database on a VPS and Access It Remotely

Mitansh Panchal -