기술스택을 쌓아보자/에러 로그 수집기

[디버깅기] airflow postgresql sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "postgres" (), port 5432 failed: FATAL: sorry, too many clients already

소리331 2023. 6. 27. 16:35
반응형

인트로

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "postgres" (172.19.0.2), port 5432 failed: FATAL:  sorry, too many clients already

서칭한 해결방안 

재시작 하면 기존에 셋팅해두었던 airflow connection 값들이 모두 사라지기 때문에, postgres docker로 cp 를 진행하였다. 

 

 

Airflow psycopg2.OperationalError: FATAL: sorry, too many clients already

I have a four node clustered Airflow environment that's been working fine for me for a few months now. ec2-instances Server 1: Webserver, Scheduler, Redis Queue, PostgreSQL Database Server 2:

stackoverflow.com

 

반응형