FranciscoRuiz04 commented on issue #47300: URL: https://github.com/apache/airflow/issues/47300#issuecomment-3500075408
Maybe you already fixed your issue @arvindmunna but this could help somebody else with the same problem. I'm running Airflow 3.1.0 with PostgreSQL version 16 as backend. What I found is that when you execute `airflow db migrate` with a custom schema other than public, Airflow does indeed use the schema name defined in `AIRFLOW__DATABASE__SQL_ALCHEMY_SCHEMA` to create all the tables it needs. However, when it tries to seed up the `log_template` table Airflow does not take into account the schema defined; that is, uses the default search path (public schema) instead. So, one possible solution is passing explicitly the search path value inside the URI like this: `AIRFLOW__DATABASE__SQL_ALCHEMY_CONN=postgresql+psychoph2:user:password@host:port/db?options=-csearch_path%3Dschema` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
