GitHub user BalaMuralibi edited a discussion: Does airflow support enabling pgbouncer on airflow side with external azure postgres 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 [email protected]. To unsubscribe, please send an email to: [email protected]
