Re: Connections - Postgres 9.2 - Mailing list pgsql-general

Hi

I control this way

if "state_change" is from longtime and "state" is idle then I use

function:

  pg_terminate_backend ( integer )  ==> return TRUE if killed-successful else FALSE

example:

# select pg_terminate_backend ( pid ) from pg_stat_activity where state='idle' and state_change < (current_timestamp - interval '1 hour');

may be helpful

NOTE: we come to decision to kill sessions in idle state more then "1 hour" after lot of discussion with application / implementation / stake-holders team

*removed history as thrown error due to mail length

Thanks

Sridhar 

OpenText