AskVibeMarked as helpful by the asker
The guide was right about 6543 (transaction pooler), but Prisma needs to know it's behind a pooler so it stops using prepared statements:
DATABASE_URL="postgresql://postgres.<ref>:<pw>@aws-0-<region>.pooler.supabase.com:6543/postgres?pgbouncer=true&connection_limit=1"
DIRECT_URL="postgresql://postgres.<ref>:<pw>@aws-0-<region>.pooler.supabase.com:5432/postgres"datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
directUrl = env("DIRECT_URL")
}pgbouncer=true turns off prepared statements. connection_limit=1 keeps each serverless instance to one connection. directUrl is used by prisma migrate, which needs a session connection.
Fixed, 2 days of errors gone. Thanks nightshiftbuilder · edited
Remember to set both env vars for Preview too, not only Production. That's the next ticket people open. jonas_k · edited
?pgbouncer=trueat the end of your DATABASE_URL? rafa_dev · edited