Supabase IPv6 Default Causes Connection Failures; Transaction Pooler Offers Fix
Supabase assigns IPv6 addresses to project hostnames by default, which causes DNS resolution errors like ENOTFOUND or ETIMEDOUT on environments that lack IPv6 support. Developers running apps locally or on platforms such as Cloudflare Workers and Windows machines are most likely to encounter these failures. Supabase provides three connection string options in its dashboard, and switching to the transaction pooler on port 6543 routes traffic through an IPv4-compatible proxy, resolving the issue. The transaction pooler does not support prepared statements, so tools like Prisma require the additional query parameter pgbouncer=true to function correctly. For database migrations and tools like pg_dump, the direct connection on port 5432 remains the recommended option.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in