Can't connect to PostgreSQL 12 trough PgBouncer
Database management in a single PHP file
Brought to you by:
jakubvrana
Menu
▾
▴
#771 Can't connect to PostgreSQL 12 trough PgBouncer
Hello,
We can't connect to a PostgreSQL 12 instance trough PgBouncer, Adminer returns :
SQLSTATE[08006] [7] ERROR: unsupported startup parameter: options
It seems that PgBouncer does not support client options like --client-encoding=utf8.
On https://github.com/pgbouncer/pgbouncer/issues/295, you can see there is a workaround with the PDO connection string.
I don't know if it will work with every version of PDO and PostgreSQL, though.
It's supported since PostgreSQL 9.1.