Re: Default session timeout in PG?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Default session timeout in PG?
Date: 2010-10-04 22:40:59
Message-ID: AANLkTinoOm1uPp9dRGEm+xaQBt4a8XRbJi_UQFjbddON@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Oct 4, 2010 at 11:52 AM, Craig James <craig_james(at)emolecules(dot)com> wrote:
> On 10/4/10 10:36 AM, Lou Picciano wrote:
>>
>> (Think I've seen the answer to this already, but:) is there any 'innate',
>> or
>>  'default' session timeout function built in to PG?
>>
>> We have certain clients who seem to timeout pretty frequently, while
>>  others seem to never time out at all; before we start diagnosing
>> networks, I want to be sure there's nothing we can do server-side to
>> ameliorate/control the problem.
>
> We discovered the other day that a whole class of Netgear routers (designed
> for small businesses) contain a bug: they cut off all idle TCP/IP
> connections after 5 minutes, and there is no way to change this behavior.
>  We threw them away.

If anyone ever needs a solid reliable simple router just put two NICs
in an old box and use arno-iptables-firewall package on linux. Single
text file, and it handles dang near anything you'd need in a home or
small business. Paint it green and it won't rust.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fábio Gibon - Comex System 2010-10-05 03:28:57 Validade dump file
Previous Message Kevin Grittner 2010-10-04 21:20:14 Re: ECPG: AUTOCOMMIT and CURSORs