Cannot connect to database on port 5432 – P1001 error and psql connection closed unexpectedly
I’m trying to run Prisma migrations and connect to my Supabase Postgres database, but the direct connection (port 5432) is failing consistently with the following error:
This probably means the server terminated abnormally before or while processing the request.
Port 6543 (pgbouncer) works fine for queries.
Port 5432 (direct) is not responding even via pg_isready.
What I’m trying to achieve:
Run Prisma migrations using the DIRECT_URL as recommended. I need the direct connection for schema updates and for prisma migrate dev/reset.
What I’ve tried:
Verified credentials and tenant ID in the connection string.
Tested multiple networks (WiFi, mobile hotspot, VPN off).
Used both aws-0-us-west-1.pooler.supabase.com and db.<project-ref>.supabase.co hosts.
Verified that the project is active in the dashboard.
Port test results:
Environment details:
OS: Windows 11
Framework: Node.js 20.x
ORM: Prisma @latest
Platform: Supabase hosted Postgres (US West region)
This probably means the server terminated abnormally before or while processing the request.
Port 6543 (pgbouncer) works fine for queries.
Port 5432 (direct) is not responding even via pg_isready.
What I’m trying to achieve:
Run Prisma migrations using the DIRECT_URL as recommended. I need the direct connection for schema updates and for prisma migrate dev/reset.
What I’ve tried:
Verified credentials and tenant ID in the connection string.
Tested multiple networks (WiFi, mobile hotspot, VPN off).
Used both aws-0-us-west-1.pooler.supabase.com and db.<project-ref>.supabase.co hosts.
Verified that the project is active in the dashboard.
Port test results:
Environment details:
OS: Windows 11
Framework: Node.js 20.x
ORM: Prisma @latest
Platform: Supabase hosted Postgres (US West region)
