Prisma Migration Error

Prisma Migrate could not create the shadow database. Please make sure the database user has permission to create databases. Read more at About the shadow database

Original error:
Database error
Error querying the database: db error: ERROR: permission denied to create database

I can run prisma db push with no problem, but NOT migrate.
This is a NextJS project
Thanks for any help resolving this matter.

Hi,

Please see this item in the 2.17.0 Prisma release notes:
“Prisma Migrate now works with cloud-hosted databases”

The solution offered by Prisma is to create two cloud-hosted databases, one being the development and the other being the shadow-database, which is also described here in the Neon docs:

Please let us know how you make out.

I can’t thank you enough. Your directive/solution worked out perfectly.

-Ken