pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDefault session timeout in PG?
4+ messages / 4 participants
[nested] [flat]
* Default session timeout in PG?
@ 2010-10-04 17:36 Lou Picciano <loupicciano@comcast.net>
0 siblings, 2 replies; 4+ messages in thread
From: Lou Picciano @ 2010-10-04 17:36 UTC (permalink / raw)
To: pgsql-admin
Gang,
(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.
If I recall correctly, PG does not, by default, timeout its connections, right?
Many thanks - Lou
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Default session timeout in PG?
@ 2010-10-04 17:52 Craig James <craig_james@emolecules.com>
parent: Lou Picciano <loupicciano@comcast.net>
1 sibling, 1 reply; 4+ messages in thread
From: Craig James @ 2010-10-04 17:52 UTC (permalink / raw)
To: pgsql-admin
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.
Craig
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Default session timeout in PG?
@ 2010-10-04 18:47 Tom Lane <tgl@sss.pgh.pa.us>
parent: Lou Picciano <loupicciano@comcast.net>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2010-10-04 18:47 UTC (permalink / raw)
To: Lou Picciano <loupicciano@comcast.net>; +Cc: pgsql-admin
Lou Picciano <loupicciano@comcast.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Default session timeout in PG?
@ 2010-10-04 22:40 Scott Marlowe <scott.marlowe@gmail.com>
parent: Craig James <craig_james@emolecules.com>
0 siblings, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2010-10-04 22:40 UTC (permalink / raw)
To: Craig James <craig_james@emolecules.com>; +Cc: pgsql-admin
On Mon, Oct 4, 2010 at 11:52 AM, Craig James <craig_james@emolecules.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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-10-04 22:40 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-04 17:36 Default session timeout in PG? Lou Picciano <loupicciano@comcast.net>
2010-10-04 17:52 ` Craig James <craig_james@emolecules.com>
2010-10-04 22:40 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-10-04 18:47 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox