Re: [D] Does airflow support enabling pgbouncer on airflow side using azure postgres external server ? [airflow]

["BalaMuralibi (via GitHub)" <gi...@apache.org>]

GitHub user BalaMuralibi edited a discussion: Does airflow support enabling pgbouncer on airflow side using azure postgres external server ?

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.
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?
```

GitHub link: https://github.com/apache/airflow/discussions/53129

----
This is an automatically sent email for commits@airflow.apache.org.
To unsubscribe, please send an email to: commits-unsubscribe@airflow.apache.org