Cant connect to supabase using accelerate
I have a problem setting up accelerate with supabase postgres. Supabase requires me to use ?pgbouncer=true at the end of the connection string. When i do it on the prisma accelerate dashboard it returns: One or more fields were invalid: [connectionString]. Tried many things but couldn't make it work. Am i doing something wrong? my connection string is similar to the following one:
postgres://[db-user].[project-ref]:[db-password]@aws-0-[aws-region].pooler.supabase.com:6543/[db-name]?pgbouncer=true
1 Reply
Prisma Accelerate and Pgbouncer both are connection poolers. You don't need to use pgbouncer if you are using Prisma Accelerate. Can you try using the direct database connection string and check if that works?