This is an automated email from the ASF dual-hosted git repository.
shahar1 pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/airflow.git
The following commit(s) were added to refs/heads/main by this push:
new 81b185005b4 Document PostgreSQL fallback host connection strings
(#69150)
81b185005b4 is described below
commit 81b185005b4d8158369e8c5711a5719148b6a28e
Author: Deepak Jain (DJ) <[email protected]>
AuthorDate: Thu Sep 17 00:03:43 2026 -0700
Document PostgreSQL fallback host connection strings (#69150)
---
airflow-core/docs/howto/set-up-database.rst | 9 +++++++++
1 file changed, 9 insertions(+)
diff --git a/airflow-core/docs/howto/set-up-database.rst
b/airflow-core/docs/howto/set-up-database.rst
index 03e0a7a627d..4fd02a5fc75 100644
--- a/airflow-core/docs/howto/set-up-database.rst
+++ b/airflow-core/docs/howto/set-up-database.rst
@@ -276,6 +276,15 @@ If you use a current Postgres user with custom
search_path, search_path can be c
For more information regarding setup of the PostgreSQL connection, see
`PostgreSQL dialect
<https://docs.sqlalchemy.org/en/20/dialects/postgresql.html>`__ in SQLAlchemy
documentation.
+.. note::
+
+ SQLAlchemy supports multiple fallback hosts for the psycopg2, psycopg, and
asyncpg PostgreSQL dialects.
+ These dialects accept repeated ``host=<host>:<port>`` query parameters,
with driver-specific port
+ requirements. See
+ `Specifying multiple fallback hosts
<https://docs.sqlalchemy.org/en/20/dialects/postgresql.html#specifying-multiple-fallback-hosts>`__
+ and `asyncpg Multihost Connections
<https://docs.sqlalchemy.org/en/20/dialects/postgresql.html#multihost-connections>`__
+ in the SQLAlchemy documentation for details.
+
.. note::
Airflow is known - especially in high-performance setup - to open many
connections to metadata database. This might cause problems for
