Does airflow support enabling pgbouncer on airflow side with external azure postgres server ?

[BalaMuralibi]

Hi,

We intend to use azure flexible server as our metadata database server, however we would like to enable pgbouncer on airflow side.
Azure flexible postgres server is availale on port 5432 and pgbouncer is not enabled.

1. Does it work ?
2. pgbouncer exporter is expected to have pgbouncer database in addition to airflow database on server. is there a way we can disable pgbouncer exporter ?

Made followng steps

pgbouncer-config-secret

[databases]
airflow-metadata = host=DBHOST dbname=airflow port=5432 pool_size=200

[pgbouncer]
pool_mode = transaction
listen_port = 6543
listen_addr = *
auth_type = md5
auth_file = /etc/pgbouncer/users.txt
stats_users = postgres
ignore_startup_parameters = extra_float_digits
max_client_conn = 2000
verbose = 0
log_disconnections = 1
log_connections = 1

server_tls_sslmode = prefer
server_tls_ciphers = normal
log_stats = 0
log_pooler_errors = 1
server_idle_timeout = 300
server_connect_timeout = 15

pgbouncer-stats-secret

postgresql://airflow_user:PASS@DBHOST:5432/pgbouncer

3. What shall i use for MetadataConnection ? Is following correct

postgresql://airflow_user:PASS@DBOST:6543/airflow-metadata?