### Apache Airflow version

2.7.1

### What happened

I missed the rc test window last week, sorry was out of town. When you use:
`values.keda.usePgbouncer: false`

The settings use re-use the pgbouncer port instead of port 5432 for postgres. You can work around this by overriding the:
`values.ports.pgbouncer: 5432` setting, but the database name is also incorrect and references the name of the database in the pgbouncer.ini file, which has an additional `-metadata` appended to the database connection name.

### What you think should happen instead

Not use the manipulated values for the non pgbouncer connection.

### How to reproduce

deploy the chart using the indicated values

### Operating System

gke

### Versions of Apache Airflow Providers

_No response_

### Deployment

Official Apache Airflow Helm Chart

### Deployment details

_No response_

### Anything else

_No response_

### Are you willing to submit PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

"""If worker persistence is enabled, scaleTargetRef should be StatefulSet else Deployment."""
        is_enabled = enabled == "enabled"
        docs = render_chart(
            values={
                "workers": {"keda": {"enabled": True}, "persistence": {"enabled": is_enabled}},
                "executor": "CeleryExecutor",
            },
            show_only=["templates/workers/worker-kedaautoscaler.yaml"],
        )
        assert jmespath.search("spec.scaleTargetRef.kind", docs[0]) == kind
    def test_default_keda_db_connection(self):