HELP - Can't reach database server at aws-0-ap-southeast-2.pooler.supabase.com:5432

[auauwolff]

Hi,

Out of nowhere, my Next JS app has stopped working and is showing the following error:

prisma:error
Invalid `prisma.staff.findFirst()` invocation:

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

Please make sure your database server is running at `aws-0-ap-southeast-2.pooler.supabase.com:5432`.

Here’s what I’ve tried so far:

• I changed my database password in case it contained special characters. It worked temporarily, but the issue has since returned.
• I verified my connection string, which matches the recommended session pool format from Supabase:
  postgresql://postgres.[PROJECT-ID]:[YOUR-PASSWORD]@aws-0-ap-southeast-2.pooler.supabase.com:5432/postgres

Please any help is much appreciated

[silentworks]

Are you on a free plan or a pro plan? have you checked that you haven't maxed the connection pooler connection limits?

[GaryAustin1]

If you use 6543 you also need some config options...
https://supabase.com/docs/guides/database/prisma/prisma-troubleshooting
5432 if you are running serverless functions will run out as you add users it is not intended for that.

[auauwolff]

Hmm not sure exactly what todo here sorry Gary

So I tried in replacing my DATABASE_URL locally to

"postgres://[db-user].[project-ref]:[db-password]@aws-0-[aws-region].pooler.supabase.com:6543/[db-name]?pgbouncer=true&connection_limit=1000"

Following the prisma troubleshooting docs you sent but now I get

[GaryAustin1]

The docs say connection_limit should be 1 or 2 as small as will work.
I don't use Prisma so not much more help.

[auauwolff]

Hey @GaryAustin1

Mate thank you so much you actually helped a lot, I got it working by updating my DATABASE_URL to:
DATABASE_URL="postgresql://postgres.[PROJECT-ID]:[PASSWORD]@aws-0-ap-southeast-2.pooler.supabase.com:6543/postgres?pgbouncer=true&connection_limit=1"

Really bad docs for this from supabase/prisma so hopefully this post can help others, thanks again

[GaryAustin1]

The docs changed very recently. They used to show the 6543 option and all the settings on the main page. Now it is in troubleshooting. You might drop a comment in issues with feedback on the new docs.