There are better options that Heroku. As Isra mentioned Heroku changes the credentials periodically. ElephantSQL has a free tier that can do the trick.
I get same shadow error on ElephantSQL. Is there free postgres cloud hosting that does not need two database urls?
Error: P3014
Prisma Migrate could not create the shadow database. Please make sure the database user has permission to create databases. Read more about the shadow database (and workarounds) at https://pris.ly/d/migrate-shadow
Original error:
db error: ERROR: permission denied to create database
0: migration_core::state::DevDiagnostic
at migration-engine/core/src/state.rs:250
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
There are better options that Heroku. As Isra mentioned Heroku changes the credentials periodically. ElephantSQL has a free tier that can do the trick.
I get same shadow error on ElephantSQL. Is there free postgres cloud hosting that does not need two database urls?