Groups > comp.databases.postgresql > #272

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

From	durumdara <durumdara@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: Windows: when the Session deleted/resources released?
Date	2011-11-03 05:34 -0700
Organization	http://groups.google.com
Message-ID	<a5e42e03-4bbf-4690-9403-13dfe7df7fcc@ek5g2000vbb.googlegroups.com> (permalink)
References	(1 earlier) <1319536517.567090@proxy.dienste.wien.at> <b80b9c60-1bcc-472b-9d15-6a3b4b89749f@t10g2000yqd.googlegroups.com> <1319703181.997995@proxy.dienste.wien.at> <f9a952be-c7b6-46b0-8ad7-2cef924a3fe3@n18g2000vbv.googlegroups.com> <1320249765.951326@proxy.dienste.wien.at>

Show all headers | View raw

On nov. 2, 17:02, "Laurenz Albe" <inv...@spam.to.invalid> wrote:
> > So:
> > In Windows the count is not usable.
> > It is ALWAYS 10!
>
> Yes, the documentation says that it does not work:http://www.postgresql.org/docs/current/static/runtime-config-connecti...

Ok, but it is nothing about 10.

>
> > I experienced that I have two ways to set these values.
>
> > 1.) Basically the postgresqls.conf
> > 2.) set parameters before query (this override 1.)
>
> > Every of them effective, I tried it with two queries from another
> > machine.
>
> That's how it is supposed to work.
>
> Did you read the documentation before you asked?

Yes, but help not showing this formula.
Timeout = Idle + (Interval * Count)

And about Windows specials, like Count = 10...

> The same thing, more or less. Setting these parameters works only
> on operatin systems that support the feature.
> The documentation will tell you details.

There is nothing about "under Windows Vista the count parameter is
based on... Higher Windows uses 10 for count".

Other problem that Windows uses msecs, PGSQL seconds.

My first fail based that I set the count in postgresql.conf, and
setsock call failed.
In this case I got the 2 hours timeout...

Thanks for your help:
   dd

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