db error
im getting this error when running wasp db migrate-dev.
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:
ERROR: template database "template1" has a collation version mismatch
DETAIL: The template database was created using collation version 2.36, but the operating system provides version 2.41.
HINT: Rebuild all objects in the template database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
0: schema_core::state::DevDiagnostic
at schema-engine/core/src/state.rs:276
--- [Error] Migrate dev failed: ------------------------------------------------
Migrate (dev) failed with exit code: 1 whats the issue here
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:
ERROR: template database "template1" has a collation version mismatch
DETAIL: The template database was created using collation version 2.36, but the operating system provides version 2.41.
HINT: Rebuild all objects in the template database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
0: schema_core::state::DevDiagnostic
at schema-engine/core/src/state.rs:276
--- [Error] Migrate dev failed: ------------------------------------------------Migrate (dev) failed with exit code: 1 whats the issue here
