© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
110 replies
ricopella

Supervisor Change Broke Local & Production

I saw the supervisor email. In my nextjs app which is using prisma, I updated my connection string to reflect what it says in my database settings. Looks like all that changed was removing
?pgbouncer=true
?pgbouncer=true
.

After that change I kept getting connection error messages. Thought maybe it was my default pool size as the input was empty. I changed it to 200. Now I get
Authentication error
Authentication error
when querying.

If i add back
?pgbouncer=true
?pgbouncer=true
and remove the default pool size, now I still get the same
Authentication error
Authentication error
Now I cant make any connection to my database locally or even in production

My prisma schema connection setup is:

datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL")
  directUrl = env("DIRECT_URL") // figure out how to make optional so not exposed in production
}
datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL")
  directUrl = env("DIRECT_URL") // figure out how to make optional so not exposed in production
}


Any help as to what I've done wrong would be greatly appreciated, my sites down till fixed
Screenshot_2024-01-08_at_9.10.37_AM.png
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements
Next page

Similar Threads

Change Branch Production Name
SupabaseSSupabase / help-and-questions
7mo ago
Cannot connect to database using supervisor port (5432) after change password
SupabaseSSupabase / help-and-questions
5mo ago
Integrating Supervisor with Existing PostgreSQL Server
SupabaseSSupabase / help-and-questions
3y ago
Issue: Restoring logical backup from production to local fails
SupabaseSSupabase / help-and-questions
3mo ago