1

I am facing this issue.

schema.prisma

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

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

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  password  String
  role      String   // Admin or Regular User
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

package.json

"@prisma/client": "^6.3.1",
    "apollo-server-express": "^3.13.0",
    "dotenv": "^16.4.7",
    "express": "^4.21.2",
    "graphql": "^16.10.0",
    "pg": "^8.13.1",
    "postgres": "^3.4.5",
    "prisma": "^6.3.1"

PS E:\backend> npx prisma migrate dev --name init
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "aws-0-ap-south-1.pooler.supabase.com:6543"

Error: P1001: Can't reach database server at `aws-0-ap-south-1.pooler.supabase.com:6543`

Please make sure your database server is running at `aws-0-ap-south-1.pooler.supabase.com:6543`.

node - 18.20 and 16.20

Improve this question
1
  • This question is off-topic for SO because it is not about programming or a software development problem: it appears to be a network or database administration issue. Commented Feb 9 at 18:31
Related questions
2643
How to show tables in PostgreSQL?
2256
PostgreSQL "DESCRIBE TABLE"
1702
How can I drop all the tables in a PostgreSQL database?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.