New jackc/pgx driver does not work well with pgbouncer metrics #56
Description
Two problems with the new jackc/pgx drvier when working with pgBouncer:
Pgbouncer works with SimpleQueryProtocol, which can be solved by:
config, err := pgx.ParseConfig(s.dsn)
config.DefaultQueryExecMode = pgx.QueryExecModeSimpleProtocolThe driver will send -- ping command to pgbouncer, which will trigger an error log periodically
Jun 30 02:11:47 rocky8 pgbouncer[109508]: C-0x55e5664ad6c0: pgbouncer/dbuser_monitor@unix(5155):6432 pooler error: invalid command '-- ping', use SHOW HELP;
Jun 30 02:11:47 rocky8 pgbouncer[109508]: C-0x55e5664ad6c0: pgbouncer/dbuser_monitor@unix(5155):6432 pooler error: invalid command '-- ping', use SHOW HELP;
Jun 30 02:11:56 rocky8 pgbouncer[109508]: C-0x55e5664ad6c0: pgbouncer/dbuser_monitor@unix(5155):6432 pooler error: invalid command '-- ping', use SHOW HELP;
The latter one seems tricky; I'm looking into it.
;-) Any thoughts on this ? @ringerc