Prisma•4mo ago

getting this error while migrating schema.prisma

postgres is used here

4 Replies

Franco•4mo ago

hey @Lavish Munjal considering that in your schema might have something like

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

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

does your DATABASE_URL have the following pattern?

postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@localhost:5432/${POSTGRES_DB}

postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@localhost:5432/${POSTGRES_DB}

Lavish MunjalOP•4mo ago

yes

Franco•4mo ago

are you using docker? or a local server? for me using docker

postgres:
    image: postgres
    ports:
      - 5432:5432
    environment:
      POSTGRES_DB: prisma
      POSTGRES_USER: prisma
      POSTGRES_PASSWORD: prisma
    volumes:
      - ./tmp/postgres:/var/lib/postgresql/data

postgres:
    image: postgres
    ports:
      - 5432:5432
    environment:
      POSTGRES_DB: prisma
      POSTGRES_USER: prisma
      POSTGRES_PASSWORD: prisma
    volumes:
      - ./tmp/postgres:/var/lib/postgresql/data

DATABASE_URL=postgresql://prisma:prisma@localhost:5432/prisma otherwise you might need to check your postgres config

Lavish MunjalOP•4mo ago

docker gonna check my postres config

Gaming

Programming

getting this error while migrating schema.prisma