Allow disabling prepared statements when using PgBouncer
Problem
We use PgBounder at GitLab and it does not support prepared statements, which are enabled by default with most drivers, such as pq
and pgx
.
Solution
Disable prepared statements at the driver level. For pq
this can be done by adding binary_parameters=yes
to the DSN, and for pgx
by enabling PreferSimpleProtocol
.