> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
