Re: Default session timeout in PG?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lou Picciano <loupicciano(at)comcast(dot)net>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Default session timeout in PG?
Date: 2010-10-04 18:47:34
Message-ID: 5296.1286218054@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Lou Picciano <loupicciano(at)comcast(dot)net> writes:
> 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.

> If I recall correctly, PG does not, by default, timeout its connections, right?

PG does not have a session timeout of any sort, default or otherwise.
I think you're looking at a network infrastructure issue. If there are
any NAT routers between those clients and the database, that would be
the place to look first.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message A J 2010-10-04 19:07:05 ECPG: AUTOCOMMIT and CURSORs
Previous Message Craig James 2010-10-04 17:52:21 Re: Default session timeout in PG?