Re: DBD::PG and long running queries and tcp stack timeout

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 thats doing
connection tracking?    tcp shouldn't time out like that even if your
query is taking multiple hours.


--
john r pierce                            N 37, W 123
santa cruz ca                         mid-left coast