Re: are there ways for 'idle timeout'?

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Konstantin Pelepelin <checat(at)pochtamt(dot)ru>
Cc: mike(at)thegodshalls(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: are there ways for 'idle timeout'?
Date: 2004-07-13 10:31:37
Message-ID: 1089714696.17493.2448.camel@stromboli
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 2004-07-12 at 10:26, Konstantin Pelepelin wrote:

> The
> > > best solution I see is having an (per session)
> > > idle_transaction_timeout or idle_connection_timeout
> > > setting. But there is no such thing in postgres!
> > > Scanning through list I've not found any workaround.

Have you looked at statement_timeout?
This doesn't do exactly what you want, but is close enough.

If you don't have it at your release, upgrade.

> > Looking into TODO I don't see any plans for it.
> > > Is it too difficult implementing or I've missed
> > > something or are there workarounds?

This might be something you could do...

Best regards, Simon Riggs

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stef 2004-07-13 10:40:00 Re: Bad dumps...
Previous Message Daniel Struck 2004-07-13 09:35:57 Re: [PHP] Secure DB Systems - How to