[GitHub] [airflow] Bhawana-Barfa opened a new issue, #29281: (psycopg2.errors.FeatureNotSupported) This ALTER TABLE command is not yet supported .While deploying airflow with Postgres

[via GitHub]

Bhawana-Barfa opened a new issue, #29281:
URL: https://github.com/apache/airflow/issues/29281

   ### Apache Airflow version
   
   Other Airflow 2 version (please specify below)
   
   ### What happened
   
   Airflow Version : 2.2.3 
   I am trying to deploy airflow with postgres on cluster with helm chart . 
When I install helm , upgrade-db goes into Error with the log error 
sqlalchemy.exc.NotSupportedError: (psycopg2.errors.FeatureNotSupported) This 
ALTER TABLE command is not yet supported.
   
[airflow_err.txt](https://github.com/apache/airflow/files/10554275/airflow_err.txt)
   Which is coming from 
https://github.com/apache/airflow/blob/main/airflow/migrations/versions/0008_1_6_0_task_duration.py
   <img width="1440" alt="Screenshot 2023-02-01 at 12 32 36 PM" 
src="https://user-images.githubusercontent.com/124127106/215976314-5755f151-11ba-4778-8afd-a2615420afc2.png";>
   
   Please let me know if Im doing anything wrong here, or suggest what need to 
done here. 
   
   
   
   ### What you think should happen instead
   
   _No response_
   
   ### How to reproduce
   
   vi values.yaml
   externalDatabase:
   type: postgres
   Insert postgres host port user and secret.
   
   
   helm install -f values.yaml -n airflow my-airflow-cluster .
   
   
   ### Operating System
   
   linux
   
   ### Versions of Apache Airflow Providers
   
   _No response_
   
   ### Deployment
   
   Official Apache Airflow Helm Chart
   
   ### Deployment details
   
   _No response_
   
   ### Anything else
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
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-unsubscr...@airflow.apache.org.apache.org

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