Postgres engine default keepalives_idle value causes setsockopt(TCP_KEEPIDLE) invalid value

[ndemashov]

Get OperationalError: connection to server at "localhost" (127.0.0.1), port 5432 failed: setsockopt(TCP_KEEPIDLE) failed: Invalid argument when run feast apply.
Because of keepalives_idle=config.keepalives_idle field in function '_get_conn' in infra/utils/postgres/connection_utils.py file. For example, to avoid this error I need to pass 'keepalives_idle=1', but that argument isn't parsed for the registry in feature_store.yaml and pass 'keepalives_idle=0' by default setting in infra/utils/postgres/postgres_config.py.

• Version: 0.33.1
• Platform: linux ubuntu 20.04
• Subsystem:

Possible Solution

Check this issue with the same problem TobikoData/sqlmesh#750. I think you shouldn't pass 'keepalives_idle=0' by default.