Switch pgbouncer LB health check to HTTP instead of TCP
corrective action Continuation for https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/issues/12515
Step 1 of https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/issues/12515 was completed, we should consider moving on to step 2 once we're confident into the reliability of the alert added in gitlab-com/runbooks!3266 (merged):
Step 2: Switch Google Load Balancer Health Check from TCP check to an HTTP health check that relies on Consul Agent's Get Local Service Health check: https://www.consul.io/api-docs/agent/service#get-local-service-health