Thanks The only admin function that look close is pg_terminate_backend(pid int) boolean Terminate a backend I tried it and it couldn't be found. It is newist. We're running PG8.2.13/GP3.3.7 >Oh, these connections aren't waiting for *database* events? Then >you should either restructure the apps or use a connection pool. >Two popular "drop in" connection poolers are pgbouncer and pgpool. We tried pgpool for awhile, but I think I'll have a look at the code first. I did find in the JDBC doc connections.close which should do the trick I suspect. Thanks > I'm really looking for the PG command to close a session. http://www.postgresql.org/docs/current/interactive/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL-TABLE -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
