pgbouncer should support multiple authentication options
While we allow setting pgbouncer['auth_type']
to anything supported by pgbouncer, we hardcode md5
into the pg_auth entry. Which is limiting.
We should support all (or most) auth_types supported by pgbouncer