Groups > comp.databases.postgresql > #262

Re: Windows: when the Session deleted/resources released?

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!newsfeed.utanet.at!newscore.univie.ac.at!aconews-feed.univie.ac.at!aconews.univie.ac.at!not-for-mail
From	"Laurenz Albe" <invite@spam.to.invalid>
Newsgroups	comp.databases.postgresql
References	<f225e285-56a8-45c3-b4ab-42b36ff67804@y32g2000yqh.googlegroups.com>
Subject	Re: Windows: when the Session deleted/resources released?
Date	Tue, 25 Oct 2011 11:54:56 +0200
X-Priority	3
X-MSMail-Priority	Normal
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
X-RFC2646	Format=Flowed; Original
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6109
Organization	MagistratWien newsserver
Message-Id	<1319536517.567090@proxy.dienste.wien.at>
X-Cache	nntpcache 3.0.1 (see http://www.nntpcache.org/)
X-Cache	nntpcache 2.3.3 (see http://www.nntpcache.org/)
Lines	32
NNTP-Posting-Host	141.203.254.23
X-Trace	1319536520 aconews.univie.ac.at 11354 141.203.254.23
X-Complaints-To	abuse@univie.ac.at
Xref	x330-a1.tempe.blueboxinc.net comp.databases.postgresql:262

Show key headers only | View raw

durumdara wrote:
> I continue the old theme what is named "When the session ends":
> http://archives.postgresql.org/pgsql-general/2011-06/msg00913.php
>
> I want to trying this in live - I thought, because somewhere some
> people thinking about replace a big ElevateDB database with
> PostgreSQL.
>
> The ElevateDB is uses "timeout" and "dead session timeout" parameter.
> The first is interval when the server saying "this is inactive
> connection", and the second is fully drop this dead session.
> If the inactive is activated (reconnect) then we can work again.
>
> So today I started and experience with two PC (Win7 server, WXP
> client).
> PG9, PGAdmin v14.
> The statement timeout is 5 minute, the tcp_keepalive is default.

[but aborted connections don't get closed on the server]

statement_timeout does not come into play here.

Could you post the result of

SELECT current_setting('tcp_keepalives_idle'),
       current_setting('tcp_keepalives_interval'),
       current_setting('tcp_keepalives_count');

Yours,
Laurenz Albe

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Windows: when the Session deleted/resources released? durumdara <durumdara@gmail.com> - 2011-10-25 01:38 -0700
  Re: Windows: when the Session deleted/resources released? "Laurenz Albe" <invite@spam.to.invalid> - 2011-10-25 11:54 +0200
    Re: Windows: when the Session deleted/resources released? durumdara <durumdara@gmail.com> - 2011-10-25 04:04 -0700
      Re: Windows: when the Session deleted/resources released? "Laurenz Albe" <invite@spam.to.invalid> - 2011-10-27 10:12 +0200
        Re: Windows: when the Session deleted/resources released? durumdara <durumdara@gmail.com> - 2011-11-02 02:17 -0700
          Re: Windows: when the Session deleted/resources released? "Laurenz Albe" <invite@spam.to.invalid> - 2011-11-02 17:02 +0100
            Re: Windows: when the Session deleted/resources released? durumdara <durumdara@gmail.com> - 2011-11-03 05:34 -0700
    Re: Windows: when the Session deleted/resources released? durumdara <durumdara@gmail.com> - 2011-10-25 08:02 -0700
      Re: Windows: when the Session deleted/resources released? Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2011-10-25 19:56 +0100
        Re: Windows: when the Session deleted/resources released? durumdara <durumdara@gmail.com> - 2011-10-27 00:24 -0700
          Re: Windows: when the Session deleted/resources released? Matthew Woodcraft <mattheww@chiark.greenend.org.uk> - 2011-10-27 13:49 +0100

csiph-web