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

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

by 소리331 2023. 6. 27.
반응형

인트로

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

 

반응형
저작자표시 변경금지

'기술스택을 쌓아보자 > 에러 로그 수집기' 카테고리의 다른 글

gcloud ModuleNotFoundError: No module named 'CommandNotFound'  (0) 2023.11.02
pypi 패키지 등록 401시 401 에러 HTTPError: 401 Unauthorized from https://upload.pypi.org/legacy/ has two factor auth enabled, an API Token or Trusted Publisher must be used to upload in place of password.  (0) 2023.11.02
Error saving credentials: error storing credentials - err: exit status 1, out: `Error spawning command line “dbus-launch --autolaunch=--binary-syntax --close-stderr”: Child process exited with code 1`  (0) 2023.08.06
python dash gunicorn RecursionError: maximum recursion depth exceeded while calling a Python object  (0) 2023.07.05
[GIT] 깃 브랜치 삭제 오류, error: The branch 'why-an-deoi' is not fully merged.  (0) 2020.10.08

관련글

댓글

티스토리툴바