Re: Connection Timeout - Mailing list pgsql-admin

From Tom Lane
Subject Re: Connection Timeout
Date
Msg-id 21967.1061213023@sss.pgh.pa.us
Whole thread Raw
In response to Connection Timeout  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
List pgsql-admin
"Anagha Joshi" <ajoshi@nulinkinc.com> writes:
> Consider the following:
> I opened 5 connections to the Postgres Server and did not use those
> connections at all.i.e. I did not perform any activity on the any
> databases.
> What happens to those connections? Are they still Active after long
> duration? Or any session timeout related parameter has to be configured?

There is no connection timeout.  I do not believe there should be one,
at least not on the server side.

We do use "TCP keepalive" mode, which means that if a remote machine
stops being contactable, connections from it will be closed after a
timeout.  But that doesn't apply for local connections.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Mendola Gaetano"
Date:
Subject: Re: get current queries
Next
From: "Jean Michel Gaudel"
Date:
Subject: Re: dbase ODBC error