Error: P1001Can't reach database server at `mydomain:5432
1. The psql connection works fine (both pooled and direct)
2. Prisma db pull works with DEBUG=prisma:* but fails normally
I have this problem from my local machine only. it works from server.
DIRECT_URL="postgresql://user:[email protected]/neondb?sslmode=require"
DATABASE_URL="postgresql://user:password@ep-cool-frost-a2lavfqb-pooler.eu-central-1.aws.neon.tech/neondb?sslmode=require&connect_timeout=15&connection_limit=20&pool_timeout=15"
4 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.Hey!
What happens in your local environment if you use the non pooled connection string as DATABASE_URL: postgresql://user:[email protected]/neondb?sslmode=require
So, DIRECT_URL and DATABASE_URL has same value, do you still get the error?
yes I have still same error.
Can't reach database server at
ep-cool-frost-a2lavfqb-pooler.eu-central-1.aws.neon.tech:5432
Please make sure your database server is running at ep-cool-frost-a2lavfqb-pooler.eu-central-1.aws.neon.tech:5432.
at <unknown> (app/(login)/actions.ts:58:34)
at async (app/(login)/actions.ts:58:20)
const { email, password } = data;
const foundUser = await db.user.findUnique({
^
where: { email },
include: {
teamMembers: { {That's strange. I tried using the neon connection string and it seems to work as expected for me.
Can you try changing your network?