Skip site navigation (1) Skip section navigation (2)

Re: Lost connections

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Donald Fraser" <demolish(at)cwgsy(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Lost connections
Date: 2003-01-30 23:53:59
Message-ID: 706.1043970839@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Donald Fraser" <demolish(at)cwgsy(dot)net> writes:
> As you can see there still existed the connection to the database that I ha=
> d established from the Java app (from my computer 192.168.100.22).

FWIW, that backend will eventually time out and go away.  The delay is
determined by whatever the TCP_KEEPALIVE code in your kernel does before
reporting the connection to be lost.  It's probably an hour or so, if
the TCP code is RFC-compliant.  I would not necessarily consider it a
good idea to shorten that delay; you'd be giving up robustness against
transient communication problems if you do.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Mintoo LallDate: 2003-01-31 02:16:00
Subject: Re: Postgres server output log
Previous:From: Tim LynchDate: 2003-01-30 23:25:26
Subject: block level db replication - eNBD?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group