Postgres Pro
Downloads
Home   >   mailing lists

Re: DBD::PG and long running queries and tcp stack timeout - Mailing list pgsql-general

From John R Pierce
Subject Re: DBD::PG and long running queries and tcp stack timeout
Date
Msg-id 4DE737AD.6030905@hogranch.com
Whole thread Raw
In response to DBD::PG and long running queries and tcp stack timeout  (Clemens Schwaighofer <clemens.schwaighofer@e-graphics.com>)
Responses Re: DBD::PG and long running queries and tcp stack timeout
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Clemens Schwaighofer
Date:
Subject: DBD::PG and long running queries and tcp stack timeout
Next
From: Clemens Schwaighofer
Date:
Subject: Re: DBD::PG and long running queries and tcp stack timeout