pooler icon indicating copy to clipboard operation
pooler copied to clipboard

Max connection lifetime?

Open eproxus opened this issue 1 year ago • 0 comments

Is there any way to achieve a max connection lifetime in the pool, even for active connections? We're running this in a network with firewalls that kills connections after 1 hour regardless of how active they are. We're seeing a lot of errors in pooler because of closed socket:

{exit,sock_closed,
      [{gen_server,handle_common_reply,8,[{file,"gen_server.erl"},{line,1208}]},
       {proc_lib,init_p_do_apply,3,[{file,"proc_lib.erl"},{line,241}]}]}

Or, alternatively, is there a way for pooler or epgsql to handle that message and self-close the connection process when the socket is closed remotely?

eproxus avatar Apr 03 '24 09:04 eproxus