vincbeck commented on issue #31759: URL: https://github.com/apache/airflow/issues/31759#issuecomment-1590045847
Did you follow the recommandations as mentioned in the [documentation](https://airflow.apache.org/docs/apache-airflow/stable/howto/set-up-database.html#setting-up-a-postgresql-database). Specifically: > For managed Postgres such as Redshift, Azure Postgresql, CloudSQL, Amazon RDS, you should use keepalives_idle in the connection parameters and set it to less than the idle time because those services will close idle connections after some time of inactivity (typically 300 seconds), which results with error The error: psycopg2.operationalerror: SSL SYSCALL error: EOF detected. The keepalive settings can be changed via sql_alchemy_connect_args configuration parameter [Configuration Reference](https://airflow.apache.org/docs/apache-airflow/stable/configurations-ref.html) in [database] section. You can configure the args for example in your local_settings.py and the sql_alchemy_connect_args should be a full import path to the dictionary that stores the configuration parameters. You can read about [Postgres Keepalives](https://www.postgresql.org/docs/current/libpq-connect.html). An example setup for keepalives that has been observed to fix the problem might be: -- 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]
