Re: Cursor timeout in postgres - Mailing list pgsql-general

From Tom Lane
Subject Re: Cursor timeout in postgres
Date
Msg-id 17404.1170785307@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cursor timeout in postgres  (Tim Tassonis <timtas@cubic.ch>)
List pgsql-general
Tim Tassonis <timtas@cubic.ch> writes:
> I try to reproduce the situation tomorrow and will also check on any
> odbc_errmsg() messages and the postmaster log.

OK.  A couple of comments: the only timeout within Postgres itself is
statement_timeout, which I think wouldn't apply to your situation even
if you had it set (but I might be wrong).  We have also heard reports
of firewalls dropping idle connections, but in that scenario you'd
not still have a working connection afterwards.

            regards, tom lane

pgsql-general by date:

Previous
From: Tim Tassonis
Date:
Subject: Re: Cursor timeout in postgres
Next
From: Andrea Arcangeli
Date:
Subject: regression in 8.8.2 [was Re: Very strange error]