Groups > comp.databases.postgresql > #262

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

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	2011-10-25 11:54 +0200
Organization	MagistratWien newsserver
Message-Id	<1319536517.567090@proxy.dienste.wien.at>

Show all headers | 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