Allow setting of arbitrary settings per pgbouncer database entry

pgbouncer supports setting of additional options per database entry. For example, you can do this:

input_database_name dbname=actual-database-name pool_size=5

Omnibus currently only supports the following settings per database entry:

• input database
• host
• port
• output database
• auth_user

In https://gitlab.com/gitlab-com/infrastructure/issues/2360 we describe the need for also being able to set pool_size, and we might want additional settings in the future. As such I'd like to request the ability to at least set pool_size, but perhaps we can support arbitrary options as well (if that's not more difficult).

cc @ibaum @jtevnan

mentioned in issue gitlab-com/infrastructure#2360 (closed)

mentioned in issue gitlab-com/infrastructure#2519 (closed)

mentioned in issue gitlab-com/infrastructure#2422 (closed)

/cc @marin

assigned to @ibaum

added Scheduled label

changed milestone to %9.5

created branch 2628-allow-setting-of-arbitrary-settings-per-pgbouncer-database-entry

mentioned in merge request !1858 (merged)

closed via merge request !1858 (merged)

mentioned in issue #2703 (closed)

mentioned in commit 2b92a60f

mentioned in commit 2e1528e9

mentioned in commit 5c8f08a0

marked this issue as related to #2571

mentioned in issue gitlab-com/infrastructure#2706

mentioned in commit c3af896b

mentioned in commit 38e96168