Re: [GENERAL] DBD::PG and long running queries and tcp stack timeout

2011-06-02 Thread John R Pierce
On 06/01/11 11:35 PM, Clemens Schwaighofer wrote: Hi, I have a script that runs a query on a remote server. The query will take quite some time to finish. Now the problem is that the tcp stack will timeout before the query is finished. is there a NAT firewall or something else in the middle

Re: [GENERAL] DBD::PG and long running queries and tcp stack timeout

2011-06-02 Thread Clemens Schwaighofer
yeah there is a NAT firewall inbetween. I can check there too. But interesting thing is, if I set the tcp_keepalive_time higher it won't time out. But still ... a bit strange. 2011/6/2 John R Pierce pie...@hogranch.com: On 06/01/11 11:35 PM, Clemens Schwaighofer wrote: Hi, I have a script