Postgres SSL SYSCALL error: EOF detected with python and psycopg
The error: psycopg2.operationalerror: SSL SYSCALL error: EOF detected The setup: Airflow + Redshift + psycopg2 When: Queries take a long time to execute (more than 300 seconds). A socket timeout occurs in this instance. What solves this specific variant of the error is adding keepalive arguments to the connection string. keepalive_kwargs = { “keepalives”: 1, … Read more