> 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
> 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.
In response to
pgsql-admin by date
|Next:||From: Thomas Kellerer||Date: 2012-05-04 11:57:47|
|Subject: Getting "ident" to work in Windows|
|Previous:||From: Albe Laurenz||Date: 2012-05-04 11:08:18|
|Subject: Re: Very long "<IDLE> in transaction" query|