Cannot connect to pgbouncer in 3.2.0 and later

[danielnelson]

After upgrading to v3.2.0 it is no longer possible to connect to pgbouncer, sql.Open returns:

ERROR: unsupported pkt type: 80 (SQLSTATE 08P01)

Here is a link to the configuration and open calls:
https://github.com/influxdata/telegraf/blob/03776088f135b040d8af93db4ee09f8bba1a5de7/plugins/inputs/postgresql/service.go#L112-L136

Git bisect indicates that it is caused by d9f21d0 overwriting the PreferSimpleProtocol in the pgx.ConnConfig.

[jackc]

I think this should be fixed on master now.

[danielnelson]

Thanks, I can verify that it is working for me now.

[danielnelson]

@jackc Apologies if this is documented somewhere, but do you have a date in mind for the next release? I'm trying to decide if I should wait for the next release or just pin to a commit sha on the next Telegraf release (scheduled for the end of May).

[jackc]

Just tagged v3.4.0.