Thread: URGENT PROBLEM: connection time-outs of postgresql backend/frontend

hello,

I posted several questions in the mailing list "general", and received no
response. I think that it is not documented where to manage the
connection time-out as far as TCP/IP connections are concerned.

My problem is the following: using a JDBC client, and long-lived
connections, I see my connections being timed-out by the postmaster after
having been idle for a given time. How could I modify the time-out time?

Could the postgresql dev team answer this?

thanks a lot,

Stan. Trademine corp.

On Thu, 29 Jun 2000, stanislas pinte wrote:

> hello,
>
> I posted several questions in the mailing list "general", and received no
> response. I think that it is not documented where to manage the
> connection time-out as far as TCP/IP connections are concerned.
>
> My problem is the following: using a JDBC client, and long-lived
> connections, I see my connections being timed-out by the postmaster after
> having been idle for a given time. How could I modify the time-out time?
>
> Could the postgresql dev team answer this?
>

 Now it is not possible, but I have in my private TODO oracle's CREATE
PROFILE with connection idle time etc. But it is far future... (7.2/3?).

                        Karel