Can't reach Database Server

Hi guys, I'm not sure why do i have this issue.
xavier@Xaviers-MacBook-Pro remember-my-cards % 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-southeast-1.pooler.supabase.com:5432"

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

Please make sure your database server is running at `aws-0-ap-southeast-1.pooler.supabase.com:5432`.
xavier@Xaviers-MacBook-Pro remember-my-cards % 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-southeast-1.pooler.supabase.com:5432"

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

Please make sure your database server is running at `aws-0-ap-southeast-1.pooler.supabase.com:5432`.
This is my .env
BETTER_AUTH_SECRET=ZtuAo4ni86gj3Qigote0zrVf4IgyWQlB
SUPABASE_DATABASE_URL=postgresql://postgres.xqgerlaqecytxfncfmav:[TRUNCATE]@aws-0-ap-southeast-1.pooler.supabase.com:6543/postgres?pgbouncer=true&connection_limit=1
SUPABASE_DATABASE_DIRECT_URL=postgresql://postgres.xqgerlaqecytxfncfmav:[TRUNCATE]@aws-0-ap-southeast-1.pooler.supabase.com:5432/postgres
BETTER_AUTH_SECRET=ZtuAo4ni86gj3Qigote0zrVf4IgyWQlB
SUPABASE_DATABASE_URL=postgresql://postgres.xqgerlaqecytxfncfmav:[TRUNCATE]@aws-0-ap-southeast-1.pooler.supabase.com:6543/postgres?pgbouncer=true&connection_limit=1
SUPABASE_DATABASE_DIRECT_URL=postgresql://postgres.xqgerlaqecytxfncfmav:[TRUNCATE]@aws-0-ap-southeast-1.pooler.supabase.com:5432/postgres
3 Replies
garyaustin
garyaustin11mo ago
Does your password have any special characters in it?
BakaPresident
BakaPresidentOP11mo ago
It does initially have ! as well as . but i believe i don't need to escape it. However add ?connect_timeout=300 to the back of direct_url seem to work for now :D
r.Og
r.Og8mo ago
Have you find a definitive solutiın other than setting timeout?

Did you find this page helpful?