Nuxt•9mo ago

Prisma & Postgres (PgAdmin4)

Hello everyone. I want to connect my Prisma application to my postgres, which I use with the windows software PgAdmin4. I launch the server on the software interface but when I want to migrate my prisma schema, I get an error on the database server. I've checked the information several times and it's all correct. My Postgres server is up and running. The error in question: Error: P1001: Can't reach database server at '127.0.0.1':'5432' The url configuration : I have of course changed the information to get it right DATABASE_URL="postgresql://postgres:[email protected]:5432/mysql?schema=public" Prisma schema:

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["driverAdapters"]
}

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

model User {
  id          Int           @id @default(autoincrement())
  name        String?       @db.VarChar(255)
  email       String        @unique @db.VarChar(255)
  password    String
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["driverAdapters"]
}

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

model User {
  id          Int           @id @default(autoincrement())
  name        String?       @db.VarChar(255)
  email       String        @unique @db.VarChar(255)
  password    String
}

Capture of PgAdmin: view image Thank you for your help

2 Replies

Attacler/Bart•9mo ago

this doesnt seem like a Nuxt question to me, maybe you can try to reach out to Prisma?

🅜🅐🅡🅐🅖🅐🅣🅐🅘🅝OP•9mo ago

I made the connection with Nuxt because I'm on it, but it's true that the problem is more on the prisma side. I'm closing the conversation

Gaming

Programming

Prisma & Postgres (PgAdmin4)