pgbouncer simple protocol queries must be run with standard_conforming_strings=on

Hi,

We are trying to enable the pgbouncer collector but we are getting the below error.

 DEBUG ] pgbouncer[pgbouncer] collect.go:234 executing query: SHOW VERSION;
[ ERROR ] pgbouncer[pgbouncer] pgbouncer.go:78 simple protocol queries must be run with standard_conforming_strings=on
[ ERROR ] pgbouncer[pgbouncer] job.go:191 check failed

For compatibility reasons, we cannot set to ON mode, but there must be a way to pass the option through the DSN. Is that possible? for example PostgreSQL: Documentation: 14: 34.2. Connection Status Functions

1 Like

Ok I managed to solve it. Was my mistake with unix type authentication that connected to different port pgsql instead of pgbouncer. Topic can close. thank you

2 Likes

cool - thanks for sharing your solution in case anyone else hits similar issues!