Edward
Explore posts from serversPPrisma
•Created by Edward on 5/15/2024 in #help-and-questions
How do I setup my Supabase DB connection string to work with Prisma Accelerate
Supabase currently provide 2 connection modes; Session and Transaction (Pooler). From all indications, using the transaction mode (with pgbouncer=true) as the connection string in my Prisma Accelerate dashboard seems to be the intended approach. However, I get
Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "26000", message: "prepared statement \"s2\" does not exist", severity: "ERROR", detail: None, column: None, hint: None }), transient: false })
On the other hand, if I set the session mode connection url on my Accelerate dashboard, I get Client Max Connections Reached
Really need some pointers here for anyone who has been able to get this to work. Thanks.6 replies