| [Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] |
> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite]