[GitHub] [airflow] potiuk commented on issue #26186: Breeze start-airflow pane issues

[GitBox <gi...@apache.org>]

potiuk commented on issue #26186:
URL: https://github.com/apache/airflow/issues/26186#issuecomment-1239613842

   This is neither breeze nor tmux problem. This is problem with `airflow db shell` for postgres and pass-through to `pysql` which should likely be improved. 
   
   You got the exact same behaviour when you use local virtualenv without either of the breeze/tmux (but you can reproduce it easily using breeze as the postgres database setup:
   
   1. Create airflow virtualenv (an easy way is to activate empty venv and use ./scripts/tools/initialize_virtualenv.py - it will use constraints and you can choose which extras to install)
   2. run `breeze --backend postgres --db-reset` (this will start and reset the postgres DB as well)
   3. exit breeze
   4. Setup your local venv airflow to connect to the Postgres db of Breeze:
   ```
   export AIRFLOW__DATABASE__SQL_ALCHEMY_CONN=postgresql+psycopg2://postgres:airflow@127.0.0.1:25433/airflow
   ```
   (you can see Postgres port number user/pasword used printed in the cheathsheet when you start breeze or find it in the docs)
   5) Run `airflow db shell`
   
   Observe the very same behaviour.
   


-- 
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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org