Postgres P1000: Authentication error

[spidertwin2]

Hello,

I was following the docs to migrate from SQLite to PostgreSQL.

blitz prisma migrate dev --preview-feature is throwing the following error-

Error: P1000: Authentication failed against database server at localhost, the provided database credentials for surabhi are not valid.
Please make sure to provide valid database credentials for the database server at localhost.

.env.local
DATABASE_URL="postgresql://surabhi:password@localhost:5432/myApp"

schema.prisma

datasource db {
  provider = "postgres"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

Thanks ☁️ ☁️

[spidertwin2]

Update: Realised this error occurred because the user surabhi was not created for postgres.

So, I created a new superuser, assigned a password and was good to go!

🌞