Question

Supabase IPv6 (IPv4 Deprecation)

Posted on March 7, 2024
Database DigitalOcean App Platform IPv6 Next.js
Asked by A G

I have Next.js 13 (app) project running on Digital Ocean App Platform, my data is stored in Supabase and I use Prisma. Everything worked great until January when Supabase deprecated IPv4, more details here: https://github.com/orgs/supabase/discussions/17817

I followed the instructions in the thread above and in the documentation: https://supabase.com/partners/integrations/prisma

I updated the env variables from postgresql://[USER]:[PASSWORD]@db.[PROJECT].supabase.co:5432/[DB] to:

DIRECT_URL: postgres://[USER].[PROJECT]:[PASSWORD]@aws-0-us-west-1.pooler.supabase.com:5432/[DB]?pgbouncer=true&connection_limit=1

DATABASE_URL: postgres://[USER].[PROJECT]:[PASSWORD]@aws-0-us-west-1.pooler.supabase.com:6543/[DB]?pgbouncer=true&connection_limit=1

On build I’m getting the error Can't reach database server at db.[PROJECT].supabase.co:5432

Does Digital Ocean support IPv6 on App Platform? In the thread on GitHub they suggest that this could cause the error.

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

KFSys

Site Moderator