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

ebereplenty profile image

Master Authentication with Auth.js, Next.js, and PostgreSQL: A Comprehensive Guide

NJOKU SAMSON EBERE -

aleclarson profile image

Postgres TypeScript bindings for "stored procedures"

Alec Larson -

bobur profile image

Migrating from Azure Database for PostgreSQL to Neon

Bobur Umurzokov -

aryprogrammer profile image

Comprehensive Guide: Creating and Running the "Sample Video Generator" with Daytona

Arya Pratap Singh -