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'

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"

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

Prisma & Postgres (PgAdmin4)

Error: P1001: Can't reach database server at '127.0.0.1':'5432'

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"

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

Prisma & Postgres (PgAdmin4)

Prisma & Postgres (PgAdmin4)

Continue the conversation

Nuxt

Continue the conversation

Nuxt

Similar Threads