Hi All, We are testing out Meltano on AWS ECS, and we have setup an Postgres db for logging to enable paralllel jobs via Airflow. When I set the database_uri to the aws postgres instance, it still tries to use the default sqlite db when i start up the airflow scheduler. Any ideas on how to get around this? Thanks!

@mike_planting Is it Meltano still trying to connect to

.meltano/meltano.db

, or is Airflow trying to connect to its own SQLite metadata DB? https://meltano.com/docs/production.html#airflow-orchestrator has some instructions on changing Airflow’s DB

Thanks, I was missing that step. Now in AWS it says the resource is busy when I try to reintall the airflow service. Is there a meltano command I can pass to kill the airflow scheduler and webserver?

No specific command, no. It’a a single long running process you’d want to SIGTERM/KILL

@gunnar this looks like an important step for our setup @mohsin @monika_rajput

yes it’s very helpful