' in transaction' problem in mod_perl/DBI/DBD-Pg environment.

Hi,

We run our webserver using mod_perl and perl/DBI/DBD-Pg .
I have observed that most of the pg backends that block other queries
are in '<IDLE> in transaction' state.  Usually sending a -INT or -TERM
to such blocking backends solve the problem.

My question is

1. Are there some precuation to be taken in perl/DBI programming
    in mod_perl environment to avoid backends getting into '<IDLE> in
transaction'
    mode?

2. Is it advisable/safe to run a daemon that TERMs such blocking backend
    at regular interval.

3. Most Importantly , If a do not have access to to the host is it
possible to
    TERMinate such backeds from  psql>

Regds
Mallah.