Re: Very long "<IDLE> in transaction" query

> Then you need to identify the web server process/thread that has
> client_port open and fix the problem there. If you get that process
> to close the transaction or terminate, your problem is solved.
> You can also terminate a database session from the server with
> the pg_terminate_backend function.

Thanks for letting me know the existence of "pg_terminate_backend(pid int)"
function. Unfortunately, this is available only from v8.4 onwards. We're
running v8.2.22.

> The interesting thing to know would be where in your web application
> a transaction got left open, so that it does not happen again.

Sure, we too are hunting out for the same.