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